5.1 Charts that say something
Someone reads your chart correctly in five seconds.
Before:03. Excel — AnalysisUnlocks:13. Portfolio & Certification
A chart succeeds when someone reads it correctly in five seconds, and this topic works from the question to the chart type rather than from the menu of shiny options. It opens the charts module because the judgement — bar for comparison, line for time, most of the gallery politely declined — matters more than the clicks. Removing clutter gets real practice: titles that state the finding, axes that start where honesty requires. The truncated axis, which makes small differences look dramatic, is covered so it can be recognised, not used.
Work through these
Choosing the chart type from the question, not the menu
The question you are answering decides the chart, not the gallery. Comparison, composition, distribution and change over time each have a natural form, and picking from the menu first is how misleading charts happen.
Titles, axes, labels and removing everything else
A chart needs a title that states the finding, labelled axes, and nothing else. Removing gridlines, legends and decoration is usually what makes a chart readable.
Combo charts and secondary axes, used sparingly
Two series on different scales can share one chart, and doing so invites the reader to compare things that are not comparable. Occasionally it is the right answer, and it needs care.
The truncated-axis trick and why you will not use it
Starting an axis somewhere other than zero exaggerates differences dramatically. This item names the technique so you recognise it in other people's charts and refuse it in your own.
Practice file
- xl-07-dashboard-starter.xlsx
Clean data plus an empty dashboard sheet with the five questions written on it.
Opens in Excel. Every name, number and address in these files is made up. No account needed to download.
Sign in to keep your progress.
Free resources
We haven't checked most of these for screen reader use yet.
Links last checked 29 Aug 2026.
Stuck here?
Ask a mentor. A real person answers, and they can see exactly which topic you're on. Usually within a couple of working days.
Checking your session…
Topics shown in module order.