Charts That Tell the Truth
Choose a chart, follow the rules of an honest one, and see how a cut axis turns a ten percent difference into a fivefold one.
In this lesson you will
- Choose a chart for a question
- Follow the rules of an honest chart
- Spot and measure a misleading axis
- Describe a chart in words
About 28 minutes
A chart is a claim
Leila has a trend to show the volunteers’ meeting. She could read out the weekly counts, but nine numbers in a row are hard to take in. A chart turns numbers into shapes, which the eye reads much faster. But a chart is also a claim, and it can mislead as easily as a sentence. This lesson teaches the few rules that keep a chart honest. To keep everything real and visible on a phone, the charts here are made of plain text, but every rule applies equally to a chart made in a spreadsheet or a plotting library.
Choosing the chart
| You want to show | Use |
|---|---|
| Compare amounts across categories | Bars |
| Change over time | A line, or bars for each period |
| Parts of a whole (few parts) | A single stacked bar, or a table |
| Link between two measures | Dots, one per row |
When in doubt, use bars or a table. Pie charts and three-dimensional effects make quantities harder to compare, and they are rarely the best choice.
The rules of an honest chart
- Start bars at zero. A bar’s length stands for an amount, so cutting the bottom off changes the story.
- Label everything. Give a title that says what is shown, name the units, and label each bar.
- Order sensibly. Time runs left to right, and categories are sorted by size unless they have a natural order.
- Show the numbers next to the bars when you can, so nobody has to guess.
- Do not rely on colour alone. Some readers cannot tell certain colours apart, and a chart should also work in black and white.
A chart made of text
The program below draws the weekly visit counts as bars of hash signs. The longest bar is scaled to fourteen characters, and each line ends with the count. Even this crude chart shows the pattern at a glance: a regular rise and fall, with the two end weeks lower. Remember what lesson 7 taught: the end weeks are partial, so a careful chart would mark them.
import pandas as pd
df = pd.read_csv("clean.csv", parse_dates=["date"])
monday = df["date"] - pd.to_timedelta(df["date"].dt.weekday, unit="D")
weekly = df.groupby(monday)["visit_id"].count()
top = weekly.max()
for day, n in weekly.items():
print(day.strftime("%d %b") + " " + "#" * round(n / top * 14) + " " + str(n))
a, b = 41, 45
for floor in (0, 40):
bar_a, bar_b = a - floor, b - floor
print("axis starts at " + str(floor) + ": bar ratio " + str(round(bar_b / bar_a, 2)))
print("true ratio:", round(b / a, 2))
print("exaggeration factor:", round(((b - 40) / (a - 40) - 1) / (b / a - 1)))
31 Aug ####### 3
07 Sep ######### 4
14 Sep ############## 6
21 Sep ######### 4
28 Sep ############## 6
05 Oct ######### 4
12 Oct ############## 6
19 Oct ####### 3
26 Oct ##### 2
axis starts at 0: bar ratio 1.1
axis starts at 40: bar ratio 5.0
true ratio: 1.1
exaggeration factor: 41
How an axis can lie
The last lines of the output compare two numbers, 41 and 45. They differ by about 10 percent: the true ratio is 1.1. Drawn with bars that start at zero, the ratio of the bar lengths is 1.1, which is honest. Now cut the axis so that it starts at 40. The shorter bar is only 1 unit long and the longer is 5, so the ratio of bar lengths is 5.0. The eye reads “five times bigger”, but the data says “10 percent bigger”. The exaggeration factor, the change the eye sees divided by the change in the data, is about 41. That is a lie told with an axis.
Is a cut axis ever allowed? For a line chart of something that sits far from zero, such as a body temperature, it can be sensible, as long as the axis is labelled clearly. For bars, where length is the message, start at zero.
Describe your chart in words
Anyone using a screen reader cannot see your chart, and many readers skim. So write the finding in a sentence next to it: “Weekly visits bounced between two and six, with no clear trend.” That sentence is the chart’s alt text and its headline in one, and it forces you to know what the chart is saying. If you cannot write it, the chart is not ready.
Using a chart to make a small difference look big, or starting a bar chart anywhere but zero. Even if it was an accident, the reader is misled, and trust is hard to win back.
The counts come from the made-up workshop file. The chart is plain text, so it has no colours. The cut axis demonstration uses two made-up numbers, 41 and 45, only to show the effect. In a real plotting tool, the same rules apply.
Practice for this lesson
Check what you learned
Five quick questions. Pick an answer and you will see straight away whether it is right and why.
Why should bar charts start at zero?
- Zero looks nicer
- It makes files smaller
- Python requires it
- A bar’s length stands for an amount, so cutting it changes the story
The cut axis made a 10 percent difference look five times bigger.
What did the exaggeration factor measure?
- The number of bars
- The change the eye sees divided by the change in the data
- The width of a chart
- The mean
It was about 41 for the cut axis.
Which chart suits comparing amounts across a few categories?
- A three-dimensional pie
- A word cloud
- Bars
- A map
Bars make lengths easy to compare.
Why should you not rely on colour alone?
- Some readers cannot tell certain colours apart
- Colour is too expensive
- Colour is banned
- Black bars are best
A chart should also work in black and white.
Why write the chart’s message in a sentence?
- It makes the chart larger
- It replaces the data
- It helps readers who cannot see it, and forces you to know the message
- It hides the axis
If you cannot write the sentence, the chart is not ready.
Summary
- A chart is a claim, and it can mislead like a sentence.
- Start bars at zero, label everything, order sensibly and show numbers.
- A cut axis can exaggerate a small difference many times over.
- Write the finding in words, for readers and for yourself.
Questions
Can I use a line chart instead of bars?
Yes, for change over time a line is often clearer. Keep the axis labelled, and if it does not start at zero, say so.
Do I need special software to make charts?
No. Spreadsheets and many free tools make good charts, and plotting libraries do too. The rules in this lesson apply to all of them.
Are pie charts always bad?
They can work for two or three clearly different parts. Beyond that, people compare angles poorly, and bars or a table are easier to read.
