Adding a chart title and axis titles with Chart Elements

Tip: Choose Save as PDF in the print dialog to download. Use A4 paper size.

Adding a chart title and axis titles with Chart Elements

Name:
Date:
Class:
A

Quick Questions

Shade in the A or B circle for each question.

1. Which button beside a spreadsheet chart lets you add a chart title, axis titles and a legend?
A Chart Elements
B Cell Styles
2. Which chart title tells the reader more?
A Chart 1
B Maths Marks for Year 8 Students
3. Your column chart shows daily rainfall. Which vertical axis title is best?
A Rainfall (mm)
B Rainfall
4. A chart shows Max temperature for each day of the week. What should the horizontal axis title be?
A Temperature (°C)
B Day of the week
5. Your chart has only ONE data series. Is a legend needed?
A No, you can hide it in Chart Elements
B Yes, every chart must show one
B

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left columnRight column
1Chart Elements > Chart Title AMax Temperature (°C)
2Chart Elements > Axis Titles BAdds a title above the chart that you can click and edit to say what the chart shows
3An axis title should say what is measured and include the unit CThe axis title has no unit, so readers cannot tell if the rain is in millimetres, centimetres or days. It should read something like Rainfall (mm).
4A chart title should describe what the chart shows, not just say 'Chart' DMaths Marks for Year 8 Students
5Vertical axis title: Rain EAdds labels to the horizontal and vertical axes so readers know what each one measures
6Chart title: Chart1 FThe title is the default name and does not describe the data. Edit it to something like Daily Rainfall for One Week.
C

Definitions

Chart Elements
D

Fill in the Blanks

Complete each line of code by filling in the missing parts.

1.
Click the chart, then click ______________
2.
Chart Elements > tick ___________
3.
Chart Elements > tick ___________
4.
Chart Elements > untick ______
5.
Chart Elements > tick ___________
E

Spot the Error

Shade in the letter of the line that contains an error.

Question 1
A title = Rainfall by Day
B xTitle = "Day"
C yTitle = "Rain (mm)"
Question 2
A title = "Daily Max Temperature"
B xTitle = "Day"
C yTitle = "Temp"
Question 3
A title = "Sales by Item"
B xTitle = "Sales ($)"
C yTitle = "Sales ($)"
Question 4
A title = "Marks by Class"
B series = 2
C legend = "off"
Question 5
A title = "Pizza Sales"
B dataLabels = "on
C legend = "off"

Answer Key

Adding a chart title and axis titles with Chart Elements
Section A: Quick Questions
Q1
A — Chart Elements
Q2
B — Maths Marks for Year 8 Students
Q3
A — Rainfall (mm)
Q4
B — Day of the week
Q5
A — No, you can hide it in Chart Elements
Section B: Match the Pairs
Q1
Chart Elements > Chart Title → Adds a title above the chart that you can click and edit to say what the chart shows
Q2
Chart Elements > Axis Titles → Adds labels to the horizontal and vertical axes so readers know what each one measures
Q3
An axis title should say what is measured and include the unit → Max Temperature (°C)
Q4
A chart title should describe what the chart shows, not just say 'Chart' → Maths Marks for Year 8 Students
Q5
Vertical axis title: Rain → The axis title has no unit, so readers cannot tell if the rain is in millimetres, centimetres or days. It should read something like Rainfall (mm).
Q6
Chart title: Chart1 → The title is the default name and does not describe the data. Edit it to something like Daily Rainfall for One Week.
Section C: Definitions
Q1
Chart Elements — The button beside a chart that adds or edits its title, axis titles (with units), legend and data labels, so anyone reading the chart knows what it shows.
Section D: Fill in the Blanks
Q1
Click the chart, then click Chart Elements
Q2
Chart Elements > tick Chart Title
Q3
Chart Elements > tick Axis Titles
Q4
Chart Elements > untick Legend
Q5
Chart Elements > tick Data Labels
Section E: Spot the Error
Q1
A — The title text must be written inside quotes, like the other lines. It should be title = "Rainfall by Day".
Q2
C — A y-axis title should include the unit so readers know what the numbers measure. It should be yTitle = "Temp (C)".
Q3
B — The x-axis shows the items, not the sales amounts. Its title should be "Item", and the sales title belongs on the y-axis.
Q4
C — The chart has two data series, so the legend must be shown to tell which colour is which group. It should be legend = "right".
Q5
B — The closing quote is missing from the text value. It should be dataLabels = "on".