Module 2: Choosing the chart · Lesson 2.5 · about 13 min
Honest charts: axes, scales and other ways charts mislead
How charts mislead, often by accident. Truncated bar axes, the lie factor, dual axes, cherry-picked periods, 3D and missing context, with an interactive axis you can drag.
Module 2 · about 13 minutes · read first: 2.2. You’ll be able to spot the common ways charts mislead, and keep your own charts honest.
1. Why this matters
A chart that exaggerates, even by accident, can lead to a bad decision, and once a manager catches one, they stop trusting your other charts. Honest charts protect your credibility. They also make you a better reader of other people’s numbers, which interviewers love to test (“what’s wrong with this chart?”).
2. The idea in one picture
Drag the slider to move where the axis starts. Watch the 2025 bar seem to grow while the data stays the same.
Falls Centre sales, 2024 vs 2025
3. Six ways charts mislead
- Truncated bar axis. Bars must start at zero. A cut axis can turn a 9 % rise into what looks like 150 %.
- Zooming a line too far. Lines may start above zero, but zooming into tiny changes makes noise look like a crisis. Show enough range for context.
- Dual axes. Two measures on two scales can be made to look related or unrelated at will. Prefer two charts, or index both to 100.
- Cherry-picked periods. “Sales up 63 % since February” sounds great, until you notice February 2025 was the worst month. State a fair comparison (same month last year, full year).
- 3D and area tricks. Tilted pies, 3D bars and pictures scaled by height (which grows area by the square) all distort.
- Missing context. “Up 29 %” without “including a new store” or “vs a target of +21 %” is a half-truth.
Maths and principle
Lie factor (Edward Tufte): size of effect shown in the graphic ÷ size of effect in the data.
With an axis starting at m, bars of values a and b show visible heights a − m and b − m. The change shown is (b − m)/(a − m) − 1; the real change is b/a − 1.
Falls Centre: a = 53,199, b = 57,838, real change = 8.7 %. With m = 50,000: shown change = 7,838/3,199 − 1 = 145 %. Lie factor = 145 / 8.7 ≈ 17.
Physical meaning: our eyes read the whole bar as the value. Cutting the bottom off is like measuring two people’s height from their waists up: the taller one looks huge.
4. Worked example
A slide says “Sunday sales double Wednesday’s!” with columns starting at 50,000. Real numbers: Sunday 86,285, Wednesday 55,998, so Sunday is 54 % higher. On the cut axis the Sunday bar looks about 6 times taller. The fix: start at zero and title it honestly: “Sunday sales are about 1.5 times Wednesday’s.”
5. Practice
- Two bars, 40 and 44, with the axis starting at 38. How much taller does the second look, and what’s the real difference?
- A line chart of margin % runs from 48 % to 50 % on the axis. Is that dishonest?
- Rewrite fairly: “Sales up 63 % since February!” (Feb 13,369; Mar 21,792; Mar last year 15,461.)
Answers
- Visible heights 2 and 6: it looks 3 times as tall (200 % taller). Real difference: 10 %.
- Not necessarily: lines may zoom. But label the axis clearly and ask whether a 2-point move matters; if not, show a wider range.
- “March sales were $21.8k, up 41 % on March last year.”
Next, Module 3: cutting clutter and using colour to focus attention.
Check yourself
Your ticks stay in this browser. Save them as a file on the course home.
Updated 2026-11-22. Northbay Goods is a made-up shop and its numbers are generated. The writing checks are simple rules run in your browser; nothing you type is sent anywhere or kept.