Course outline / Charts and visualisation
Lesson 52 of 75 · Intermediate · 3 exercises
Choosing the right chart
Trends over time, parts of a whole, and comparisons, each with the chart that suits it.
What you'll practise
- Show a trend with a line Chart
- Compare months with columns Chart
- Show shares with a pie Chart
Show a trend with a line
A line chart shows how something changes over time, so the eye follows the trend.
Insert a Line chart of Visitors: labels A2:A6, values B2:B6.
Compare months with columns
Column charts compare separate amounts side by side.
Insert a Column chart of Sign-ups: labels A2:A6, values C2:C6.
Show shares with a pie
A pie chart shows how a whole is split into parts. Keep it to a few slices.
Insert a Pie chart of Sign-ups by month: labels A2:A6, values C2:C6.
Try it in a real spreadsheet
Every step checks your answer instantly and tells you exactly what to fix.