Advanced
60 mins
Teacher/Student led
+80 XP
Pupils work on their own device

Printing Selected Charts

Learn to export spreadsheet charts as clean PDFs: a chart-only page and a combined chart-plus-data page. Use a dedicated chart sheet, tight print ranges, and print preview so outputs suit a supervisor, sponsor, or Specialism portfolio check.

Teacher Class Feed

Load previous activity

    1 - Introduction ~5 mins

    Today you will

    • save a PDF that shows only your chart
    • check a block of numbers in print preview
    • save a PDF with your chart and its numbers on one page

    Warm-up

    Illustration for IntroductionThink of one chart in your Something Real sheet. If your Work Experience supervisor only had 30 seconds, would you send the chart, the numbers, or both on one page?

    2 - Key Concepts ~5 mins

    A chart-only PDF shows the chart and almost nothing else.

    A chart-plus-data PDF puts the chart and its table of numbers on one page.

    Print preview shows the page before you save it, so you can fix problems first.

    A PDF looks the same on any phone or computer.

    Example

    A sponsor asks if sales are going up, so you send the chart alone. A club treasurer wants to check costs, so you send the chart with its table.

    3 - Step-by-step Task ~18 mins

    Follow the steps in the box below to save a PDF that shows only your chart. Use {{code:sm3_interpretation_practice}}, your weekly sales practice sheet.

    If you do not have it, make a new sheet with that name in {{code:09_specialism/sm3/}}. Paste this table into cell {{cell:A1}}, then select {{range:A1:B7}} and insert a column chart.

    WeekSales (€)
    Week 145
    Week 252
    Week 348
    Week 495
    Week 550
    Week 655

    4 - Common Issues ~3 mins

    Common problems

    • The PDF has lots of empty pages. Hide spare rows and columns around your chart and table, then check print preview.
    • The chart is tiny or cut off. Make it bigger on the {{code:chart_only}} sheet and switch to Landscape.
    • I can't find my PDF. Look in your Downloads folder, then move it into {{code:Project_Portfolio/09_specialism/sm3/}}.

    5 - Independent Practice ~19 mins

    Independent Practice

    Your goal: Save two final PDFs of your Something Real chart.
    Time: ~20 minutes
    Task: Open {{code:sm3_chart_data_page}} in {{code:09_specialism/sm3/}}. Check print preview before each save.
    1. Copy your chart to a {{code:chart_only}} sheet and save it as {{code:sm3_chart_only.pdf}}.
    2. Back on the data sheet, make sure the chart sits beside its table.
    3. Right-click the spare columns and rows around them and choose Hide.
    4. Click {{menu:File -> Print}}, choose the current sheet and set Landscape.
    5. When the chart and table fit on one page, save it as {{code:sm3_chart_with_data.pdf}}.

    If your chart isn't ready, use {{code:sm3_interpretation_practice}} and tell your teacher.

    Success criteria:
    • {{code:sm3_chart_only.pdf}} shows one big, clear chart.
    • {{code:sm3_chart_with_data.pdf}} shows the chart and its numbers on one page.
    • Both files are in {{code:Project_Portfolio/09_specialism/sm3/}}.
    123learn · Online learning platform

    Unlock the full learning experience

    You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.

    Hundreds of curriculum-aligned lessons
    Interactive activities in every lesson
    Printable resources & progress tracking
    Copyright Notice
    This lesson is copyright of Coding Ireland 2017 - 2026. Unauthorised use, copying or distribution is not allowed.
    🍪 Our website uses cookies to make your browsing experience better. By using our website you agree to our use of cookies. Learn more