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

    Illustration for Introduction

    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

    Think 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