Today you will
- turn a list of costs into a bar chart
- move the chart so your numbers show
- save your own chart as {{code:06_ka2_charts}} for Key Assignment 2
First, open {{code:05_ka1_best_spreadsheet}} and check that you have a {{code:06_charts}} folder.
Warm-up
Aoife makes phone cases as a side hustle. Here are her setup costs. Which one costs the most? Which one would you cut first?
| Item | Cost (€) |
|---|---|
| Stickers | 45 |
| Packaging | 28 |
| Promo cards | 15 |
| Postage | 60 |
| Table hire | 40 |
The data range is the block of cells the chart reads, both the labels and the numbers.
A column chart uses tall bars to compare numbers side by side. A bar chart is the same, but the bars lie flat.
A chart title tells the reader what the chart is about.
The chart type is the style of chart, like column, bar or pie.
Example
Aoife, who makes phone cases, has five setup costs. Which bar will be tallest in her chart, and which will be shortest?
Now you will build a practice chart from Aoife's five costs. Follow the steps in the box below for your app. This file is only for practice.
| Item | Cost |
|---|---|
| Stickers | 45 |
| Packaging | 28 |
| Promo cards | 15 |
| Postage | 60 |
| Table hire | 40 |
Common issues
- Is your chart missing the item names? Select both columns with the headings, and insert the chart again.
- Is the chart covering your numbers? Drag it by its edge until every cell shows.
- Is the wrong bar the tallest? Check the Cost cells for typos or a € sign, and type plain numbers.
Portfolio Build
- Open {{code:06_charts}} and make a new spreadsheet called {{code:06_ka2_charts}}.
- Copy the Item heading and your items from {{code:05_ka1_best_spreadsheet}} to {{cell:A1}}.
- Copy the Cost heading and those costs to {{cell:B1}}.
- Select your data with the headings and insert a column chart.
- Give the chart a title with your project name, then drag it below your data.
- In {{cell:D1}}, type the sentence from the box and fill in the gaps.
No budget file? Type five costs from your project.
- {{code:06_ka2_charts}} is saved in {{code:06_charts}}.
- My chart shows my own project costs and has a clear title.
- The chart does not cover my numbers.
- My sentence names my biggest cost and what to do.
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.
This lesson is copyright of Coding Ireland 2017 - 2025. Unauthorised use, copying or distribution is not allowed.