Choosing the right chart for the question
TL;DR
Difficulty: Beginner
Say the question in one sentence first, and the chart nearly chooses itself.
- Comparison and ranking: sorted bars from zero, or a table for exact lookup.
- Change over time: lines, bars only for a few periods.
- Part to whole: stacked bars, a pie only for two or three parts.
- Distribution: a histogram, or a box plot to compare groups.
- Relationship: a scatter plot, which shows that things move together, never why.
- Deviation: diverging bars from zero. People judge position on a shared baseline far better than angle or area, which is why bars and lines win so often.
What to read first
Most charts are chosen by habit, or by whatever the spreadsheet offers first. This chapter turns that round: start from the question, name its type, and pick the chart that answers it. One invented outdoor gear shop in Limerick, eight questions from its owner, and the research that explains why bars beat pies.
The chart follows the question
Most people choose a chart the way they choose a font: by habit, or by whatever the spreadsheet offers first. Then they wonder why the meeting goes sideways. The fix is to reverse the order. Before you pick bars, lines, a pie or a scatter, say the question out loud in one sentence. The kind of question decides the kind of chart, almost every time.
There are only a handful of question types in business reporting. The Financial Times built its well known Visual Vocabulary poster around nine of them (deviation, correlation, ranking, distribution, change over time, magnitude, part to whole, spatial and flow)1, and the UK Government Analysis Function, a handy reference on this side of the Irish Sea too, gives the same advice in plainer words: match the chart to the relationship you want to show, and if you cannot state the message in a sentence or two, the chart is not ready2. I work the same way with clients. Every analytics project I take on starts from the decision the numbers should support, not from a dashboard, and the chart question is that idea in miniature. If you want the longer case for it, read start with the decision, not the dashboard.
This article is the second in a series on charts that tell the truth. The first chapter covered why a chart at all, and when a table does the job better. Here we pick the right chart for the job.
| The question sounds like | Question type | Chart to reach for |
|---|---|---|
| Which is biggest? How do they compare? | Comparison | Bars, sorted |
| Which comes first, second, third? | Ranking | Sorted bars, or a table for exact lookup |
| How has it moved? | Change over time | Lines (bars for a few periods) |
| What is it made of? | Part to whole | Stacked bars, a pie only for two or three parts |
| What is typical, and how spread out? | Distribution | Histogram, box plot |
| Does one thing move with another? | Relationship | Scatter, with a trend line |
| Are we above or below the line? | Deviation | Diverging bars |
Example: five questions from the owner of Shannon Outfitters
Shannon Outfitters is an invented outdoor gear brand in Limerick. It sells online at shannonoutfitters.example and through one shop on O'Connell Street. Its owner, Aoife, sends her analyst Sam five questions before the quarterly review. Every number in this article is invented for the example.
- "Which product category made us the most money last quarter?" That is a comparison.
- "How has online revenue moved over the last two years?" Change over time.
- "Where do our online orders come from?" Part to whole.
- "What does a typical online order look like?" Distribution.
- "Does spending more on paid search bring in more revenue?" Relationship.
Sam writes the question type next to each one before opening the spreadsheet. That takes a minute and saves the hour of fiddling that usually follows. The rest of this article walks through each question in turn, plus two more types Aoife will ask about sooner or later: ranking and deviation.
Why some charts are easier to read than others
Before the individual charts, one piece of research explains almost every rule that follows. In 1984 the statisticians William Cleveland and Robert McGill asked people to judge values from charts and measured how wrong they were. They ranked the ways a chart can encode a number, from the most accurate to the least3:
| Rank | How the number is shown | Typical chart |
|---|---|---|
| 1 | Position along a common scale | Bars or dots from the same baseline |
| 2 | Position along scales that are not aligned | Small charts side by side |
| 3 | Length, direction, angle | Stacked segments, slopes, pie slices |
| 4 | Area | Bubbles, treemaps |
| 5 | Volume, curvature | 3D shapes |
| 6 | Shading, colour saturation | Heatmaps |
In 2010 Jeffrey Heer and Michael Bostock repeated the experiment online with many more people. The ranking of position and length held, and both angle and circular area were read significantly worse than position4. So the most accurate thing you can ask the eye to do is compare positions against one shared baseline. That is exactly what a sorted bar chart and a line chart ask for, and it is why they win so often.
Example: Sam compares two numbers two ways
Sam takes two of Aoife's numbers: online orders from email (330) and from direct visits (283). Drawn as two bars from the same baseline, the eye compares the tops of the bars and sees at once that email is a bit more than direct. Drawn as two slices of a pie, the eye has to compare two angles that start at different places on the circle. Most people can tell which slice is bigger only when the gap is large. Here it is 47 orders out of 2,360, about two percentage points, and the pie hides it. Nothing about the data changed. Only the encoding did, and with it the accuracy of every reader in the room.
Comparison: sorted bars
When the question is "which is biggest", use bars, and sort them from largest to smallest. Sorting does the reader's first job for them. The Analysis Function guidance says the same: rank bars by value unless the categories have a natural order, such as age bands or months2. Two more rules come straight from the perception research. Bars start at zero, because the length of the bar is the number, and a bar cut short tells a lie about its own length (the third chapter, how charts lie, shows how badly). And if one bar is the answer, give it the colour and let the others go grey.
A note on long labels. A common piece of advice is to turn the bars sideways when the category names are long. On my own website every chart sets its category labels at 45 degrees instead, so long names still fit on a phone, and every chart can open in a full screen view when a reader wants to look closer. Either approach works. What matters is that nobody has to tilt their head to read a label lying flat on its side.
Example: which category made the most money
Sam lists last quarter's revenue (July to September) by category: jackets €182k, footwear €146k, tents €97k, rucksacks €74k, sleeping bags €51k and accessories €38k. The spreadsheet's default puts the categories in alphabetical order, so accessories comes first and jackets sits somewhere in the middle. Sam sorts them, starts the axis at zero, highlights jackets, and writes a title that answers Aoife's question instead of naming the data.
Aoife reads the answer in the title, checks it against the bars in a second, and can see the next question coming: footwear is not far behind.
Ranking: sorted bars, or simply a table
Ranking looks like comparison, and the chart is the same sorted bar. The difference is the question. A ranking asks about order ("what is in the top five"), so the exact positions matter more than the size of the gaps. When the reader needs to look up a precise figure, a ranked table is often better than any chart, which is the point the first chapter of this series makes at length. There is one trap: a ranking always ranks by something, and a different measure can give a different order. Say in the title which measure you ranked by.
Example: which five products earn a place on the homepage
Aoife wants the five bestsellers on the homepage. Sam ranks last quarter's products by units sold and puts the result in a table, because the homepage team needs the exact names and numbers rather than the shape.
| Rank by units | Product | Units sold | Revenue |
|---|---|---|---|
| 1 | Burren waterproof jacket | 412 | €61,388 |
| 2 | Galtee walking boots | 365 | €47,085 |
| 3 | Merino base layer | 340 | €16,660 |
| 4 | Trekking poles, pair | 298 | €11,622 |
| 5 | Lough two person tent | 118 | €28,202 |
Then Sam adds one line under the table: ranked by revenue, the tent moves up to third place and the trekking poles drop to fifth. If the homepage is there to sell volume, the units ranking is right. If it is there to earn money, the revenue ranking is. Aoife picks revenue, and the order changes. The data did not change. The question did.
Change over time: lines
When the question is "how has it moved", time runs along the horizontal axis, from left to right, and a line joins the points. A line shows the shape of the movement: the trend, the seasonal rhythm, the sudden break. The eye reads the slope between neighbouring points, which a set of separate bars makes harder.
Bars are fine for time when there are only a few periods, say four quarters or five years, and the reader cares about each period's total rather than the path between them. The Analysis Function adds two useful limits: use bars over time only when the periods are equally spaced, and keep a line chart to about four lines before it turns into spaghetti2. A line chart may also start its vertical axis above zero when the movement is the point, because the eye reads the slope, not the length from the baseline. Chapter three explains when that is fair and when it is not.
Example: how online revenue moved over two years
Sam plots monthly online revenue from November 2024 to October 2026 as one line.
Two things jump out that no table of 24 numbers would show as quickly. First, the rhythm: every December spikes and every January falls back, so a bad January is not news. Second, the growth: every month in the second year sits above the same month in the first. Sam writes that second point as the title, because it is what Aoife asked. If Aoife had asked "how did each year end", four yearly totals as bars would have been the better answer.
Part to whole: why the pie struggles
"What is it made of" is the question pie charts were invented for, and it is the one where they most often let the reader down. A pie asks the eye to compare angles and areas, which sit in the third and fourth rows of the Cleveland and McGill ranking3. Robert Kosara and Drew Skau later found that people do not even read pies purely by angle: area and arc length play a part, and pie variants that distort the shape (exploded slices, ellipses, 3D) made the errors larger5. With two or three slices that hardly matters. With eight it does, because neighbouring slices of similar size become impossible to rank, the labels crowd together, and the reader starts matching colours to a legend.
It is fair to say what pies do well. Stephen Few, one of their sharpest critics, grants that a pie announces "part of a whole" more directly than any other chart6. Claus Wilke's textbook concludes that no single chart for proportions wins every time, and that pies are good at showing simple fractions such as a half or a quarter in very small datasets, while bars are better for comparing the parts with each other7. The Analysis Function puts a practical limit on it: five categories or fewer, one of them dominant, sorted, starting at twelve o'clock, labelled directly2. My own rule of thumb is stricter: two or three parts, or a bar chart.
To read a share, you divide the part by the whole:
Here is the count or amount for one category, is the total of all categories, and is that category's percentage of the total. If percentages make you uneasy, Foundations: percentages builds them up from scratch.
Example: where online orders come from, shown wrong first
Last quarter Shannon Outfitters took 2,360 online orders. Sam's first draft is the default pie from the analytics tool, with eight traffic channels.
Try it honestly: without reading the numbers, is email bigger than direct? Is paid social bigger than organic social? Now the same data as sorted bars, shown as shares so the "part of a whole" message survives.
The share for email works out as:
So is 14.0%, and every comparison that was a guess in the pie is now a glance: email (14%) beats direct (12%), paid social (9%) beats organic social (7%). The title states what Aoife needs to know: the two search channels bring almost half the orders, which matters the day someone suggests cutting the paid search budget.
Example: when the parts change over time, stack the bars
Aoife's follow up question is "is online taking over from the shop?" That is part to whole and change over time at once. A row of pies, one per year, would ask the eye to compare angles across separate circles, the worst of both. Stacked bars put each year's total on one common baseline and split it into its parts.
There is a catch worth knowing, and it follows from the ranking. The bottom segment (online) sits on the shared baseline, so its growth is easy to read. The top segment (shop) floats on top of a moving base, so the eye has to compare lengths that are not aligned, which is harder. Put the part you care about most at the bottom. Wilke makes the same point and advises against long sequences of stacked bars with more than two segments for this reason7. If Aoife wanted to compare the shop's decline year by year in detail, Sam would draw it as its own line.
Distribution: histograms and box plots
"What does a typical order look like" is not a question about one number. It is a question about many numbers and how they spread. An average alone answers it badly, because one large tent order pulls the mean up while most orders stay small (the article on why averages mislead goes deep on this). The chart for a distribution is the histogram: cut the range of values into equal bins, count how many values fall in each, and draw the counts as touching bars.
How many bins? Too few and the shape vanishes, too many and it turns into noise. A classic starting point is Sturges' rule from 19268, which fits on one line:
Here is the suggested number of bins, is the number of values, and is the power you would raise 2 to in order to get (how many times you can halve before you reach 1). Foundations: logarithms explains logarithms from the ground up. Treat the result as a first guess. Sturges built the rule with roughly bell shaped data in mind, and shop data rarely is: order values have a long tail of rare large orders. In practice, round bin widths (€10, €25, €50) read better than whatever the formula gives.
A box plot is the compact cousin of the histogram, popularised by John Tukey9. It draws five numbers: the smallest value, the first quartile (a quarter of the values sit below it), the median (half below), the third quartile (three quarters below) and the largest value, with unusually large or small values drawn as single dots. The middle box covers the middle half of the data, and its width is the interquartile range:
Here is the first quartile, the third quartile, the interquartile range, and any value above the is drawn as a separate dot rather than inside the whisker. Foundations: spread covers quartiles and the interquartile range. The chart library on this site does not draw box plots, so when I need one here I give its five numbers as a table, and the histogram does the visual work. Box plots shine when you compare several distributions side by side, for example order values per channel.
Example: what a typical online order looks like
Sam takes the 2,360 online orders from last quarter. Sturges suggests:
So bins. But the values run from €6 to €689, and 12 equal bins over that range would each be about €57 wide, which would crush most orders into the first two bars. So Sam does what the rule's caveat suggests and keeps round €25 bins up to €250, which covers 2,320 of the orders, and mentions the 40 larger orders in the title rather than stretching the axis for them.
The shape tells Aoife what one average could not: the typical order is a pair of socks, a base layer or a hat, somewhere between €25 and €75, and a long tail of jackets, boots and tents stretches out to the right. Sam adds the box plot's five numbers as a table:
| Smallest | First quartile | Median | Third quartile | Largest |
|---|---|---|---|---|
| €6 | €36 | €61 | €98 | €689 |
The interquartile range is €98 minus €36, so €62, and the upper fence is €98 plus 1.5 times €62, so €191. Every order above €191 counts as unusually large. The mean order value is €77, well above the median of €61, which is the long tail at work. If Aoife is setting a free delivery threshold, this chart is the one she needs, not the average.
Relationship: scatter plots
"Does one thing move with another" calls for a scatter plot. Each dot is one observation, here one week, placed by two measures at once: one along the horizontal axis, one up the vertical. If the dots climb from left to right, the two move together. A trend line drawn through them shows the general direction. The strength of a straight line relationship is summed up by Pearson's correlation coefficient:
Here is the number of dots, and are the two measures for dot , and are their means, and runs from (a perfect falling line) through (no straight line pattern) to (a perfect rising line). Foundations: correlation walks through it slowly.
Then the warning that belongs next to every scatter plot: correlation is not causation. Two measures can move together because one drives the other, because a third thing drives both, or by coincidence. The scatter shows that they move together. It cannot tell you why. Chapter three of this series shows how charts manufacture correlations that are not there at all.
Example: does more paid search spend bring more revenue
Sam plots 12 weeks from the summer and autumn: weekly paid search spend against weekly online revenue.
Sam works out the three sums from the 12 weeks: the cross products add up to 31.94, the squared spend deviations to 14.16 and the squared revenue deviations to 77.34. So:
An of 0.97 is a very strong positive relationship. The trend line says that, across these weeks, each extra €1,000 of spend went with roughly €2,260 more revenue. Before Aoife doubles the budget, Sam points out the third thing: the budget was raised in the weeks before the autumn walking season on the Burren and the Galtees, when demand was rising anyway. Some of that revenue would have come without the ads. The honest answer to "does it bring more revenue" is a test, for example switching paid search off in a holdout period and comparing, and the article on statistical significance and error margins explains how to read the result. The scatter plot earned the question. It did not answer it.
Deviation: diverging bars
"Are we above or below the line" is a question about the gap, not the level. When Aoife asks how the shop did against target, a chart of the actual numbers and a chart of the targets makes her subtract in her head, month by month. A diverging bar chart does the subtraction for her: each bar is the gap, growing up from zero when the month beat target and down from zero when it missed.
The gap can be shown in euro or as a percentage:
Here is what happened, is what was planned, is the gap in the original unit (euro) and is the same gap as a percentage of the target. Use euro when the size of the business is stable, a percentage when you compare units of very different sizes. Foundations: percentages has more on percentage change.
Example: online revenue against target this year
Sam takes this year's monthly online revenue (the same numbers as the line chart above) and the monthly targets from the plan, and draws only the gap.
Sam checks the title against the bars before sending it: from June to October the months go miss, beat, miss, miss, beat. Three misses in five months. A finding title is a claim, so it gets checked like one.
For August, actual revenue was €94k against a target of €98k:
A of in one month is small. Two of them back to back in late summer, after a strong spring, is a pattern worth a conversation. The diverging bars make that pattern visible in a way two overlapping lines would not.
Which chart for which question: the whole decision
Here is the whole method as one decision. Start from the question, follow the branch, and finish every chart the same way: with a title that states the finding.
Two kinds of chart are missing on purpose. Maps answer "where", and flow diagrams answer "what leads to what". Both are real question types (the FT poster lists them as spatial and flow1), and the tenth chapter of this series covers technical diagrams that people understand. Uncertainty, the question of how sure you are, gets its own chapter too: showing uncertainty honestly.
Example: Sam's one page for the quarterly review
Sam puts the method to work on Aoife's five questions and the two that followed, and the review pack reads like this:
- Which category made the most money? Sorted bars, jackets highlighted, title "Jackets made the most money last quarter".
- Which products go on the homepage? A ranked table by revenue, with a note that the order changes by units.
- How has online revenue moved? One line over 24 months, title "Online revenue rose every month against the same month a year earlier".
- Where do online orders come from? Sorted bars of shares, both search channels highlighted, the pie retired.
- Is online taking over from the shop? Stacked bars per year, online at the bottom.
- What does a typical order look like? A histogram in €25 bins plus the five number table.
- Does paid search bring revenue? A scatter with a trend line, and a proposal for a holdout test.
- Are we on target? Diverging bars, with the late summer misses highlighted.
Eight questions, six chart types and two tables, and not one chart chosen because it looked nice. Aoife gets through the pack in ten minutes, says it's grand, and spends the rest of the meeting on decisions, which is the whole point.
Conclusion
Choosing a chart is not a matter of taste. It is a matter of the question. Say the question in one sentence, name its type, and the chart nearly chooses itself: sorted bars for comparison and ranking, lines for change over time, stacked bars for parts of a whole, a histogram for distribution, a scatter for relationships and diverging bars for gaps to a target. Behind every one of those rules sits the same finding: the eye judges position on a shared baseline far better than angle or area. Pies earn their place only with two or three parts. Scatter plots show that things move together, never why. And every chart ends with a title that states what the reader should take away, checked against the chart before anyone else sees it.
The next chapter, how charts lie, and how to catch them, takes the right chart and shows how a truncated axis, a second axis or a cherry picked window can still make it mislead.