The Analyst's Path

Choosing the right chart type

Choosing the right chart type means letting the message decide the form. You write the one sentence you want a reader to believe, and a lookup table turns its message type and a few facts about the data into a form that can carry it. It matters because the data doesn't suggest the chart: the same numbers support any of seven message types, depending on the question you asked.

7 min readPart of Chart-Choice Grammar: Match the Chart to the MessageOpen in course mode

Advertisement

Write the sentence first. Not the title, not yet, and not the chart. Write the plain sentence you want a reader to believe when they look away, and put it above the data while you work.

Here are four sentences about the same table of state-wise revenue.

SentenceTypeWhat the reader must be able to do
Maharashtra is the largest state at 31.2 crorecomparisonrank the categories, read one value
Revenue has grown every year since FY22change over timefollow one series along an ordered axis
Six states make up the whole book, and two of them are 44.8% of itcompositionsee parts against a whole
States with more stores grow fasterrelationshipsee two variables move together

Four sentences, four types, four different charts, one dataset. Look at that table again, because most analysts arrive with the opposite instinct. They believe the data suggests the chart. It doesn't. The same numbers will support any of the seven message types, depending on which question you asked. Your form has to answer that question. Describing whatever table you happen to hold isn't the job.

Advertisement

What are the seven message types?

Seven types cover essentially everything an analyst claims.

#Message typeThe claim, in shapeTypical verb
1ComparisonA is larger than B across a set of categoriesexceeds, leads, trails
2Change over timeX moved from one value to another along an ordered axisrose, fell, flattened
3Compositionthe parts of a whole are distributed in this waymakes up, accounts for
4Relationshiptwo measured variables move togetheris associated with, predicts
5Distributionthe values are spread across a range in this shapeclusters, is skewed, is bimodal
6Rankingthe ordered position is the point, not the levelfirst, top five, bottom quartile
7Deviationthe gap from a reference is the pointagainst budget, versus the index

Ranking and deviation are arguably special cases of comparison, and some textbooks fold them in. They're kept separate here for a working reason: they choose different forms. A ranking message wants a sorted dot plot or bar, with the order carrying meaning. A deviation message wants a diverging bar centred on zero. Run both through the general comparison rule and you'll get the wrong answer often enough for it to matter.

How do you check you've picked the right message type?

To test whether you've classified correctly, try to break your own sentence. If it can be argued for with a different chart form, you've probably written two sentences joined by a comma. Split them. One message per chart is a rule you'll keep meeting in the decluttering and action-title work that follows. It starts here, because a form that has to carry two claims will carry neither.

The shared form heuristic

Six inputs, one output. This is the chart-choice table the drills grade against and the checker runs, and it's short enough to memorise.

Six inputs go in. The message type comes from the seven above. Next, n, the number of categories or points, and whether the horizontal variable is ordered, meaning time or a scale with an intrinsic sequence. Then s, the number of series, and whether the parts sum to a meaningful whole with every value non-negative. Last, whether the reader's task is lookup or precision-critical.

How do you use the chart-choice table?

#MessageConditionPrimary formPermitted alternateRuled out
1Comparisonn ≤ 12, labels shortcolumn, sorteddot plotpie, line, area
2Comparisonn ≤ 12, any label over about 18 charactershorizontal bar, sorteddot plotrotated column labels
3Comparisonn > 12dot plot, sortedhorizontal barcolumn, pie
4Comparisons = 2, same unitspaired bar or dot plot with two marksslope chartstacked bar
5Change over timeordered, points ≥ 5, s ≤ 4linecolumn if each period is a discrete eventarea, slope, pie
6Change over timeordered, points ≥ 5, s > 4small multiples of lines, shared scaleline with one accent seriesone crowded line chart
7Change over timeexactly 2 periods, 3 ≤ n ≤ 15slope chartdiverging bar of the changetwo pies
8Change over timepoints ≤ 4 and the message is a leveldot plot with a reference linea sentencebar with a truncated axis
9Composition2 or 3 parts, one periodstacked bar, singlethe numbers in textpie
10Composition4 or more parts, one periodsorted horizontal bartreemap if a hierarchy existspie, donut
11Compositionparts over few periods, shares are the point100% stacked bar, ≤ 5 partssmall multiples of linesstacked area
12Compositiona total decomposed into signed driverswaterfalltable with a check columnpie, stacked bar
13Relationshiptwo continuous variables, n ≥ 12scatterscatter with a fitted line and stated rbar of group means
14Relationshiptwo variables plus a third magnitudebubble, with area encodingsmall multiples of scatters3-D scatter
15Distributionone variable, n ≥ 200histogram, bin width stateddensity curvebox plot alone
16Distributionone variable, n < 200dot plot, every observation shownstrip plothistogram
17Distributionseveral groups comparedbox plot with the points overlaidsmall multiples of histogramsbox plot alone, bar of means
18Rankingthe order is the messagesorted dot plotsorted horizontal baralphabetical anything
19Deviationgap from a reference or a budgetdiverging bar centred on zerodot plot with a reference linestacked bar
20Anylookup or precision-critical, n ≤ 20 rowstabletable with an in-cell barany chart

Two tie-breaks settle the cases where more than one row applies. When a comparison rule and a composition rule both fit, ask whether the reader needs the whole. If the total isn't part of the claim, the comparison rule wins and you draw a sorted bar instead of a stacked one. And when another rule and the chart-choice table's lookup rule both fit, the lookup rule wins. A reader who has to read a number off a chart to two decimal places has been given the wrong object.

The four permanent fails sit outside the table and override everything in it. No three-dimensional effects. No dual axes. No truncated baseline where the mark encodes length. No pie with more than three slices, and no pie with a legend at any slice count. Section 9 gives the arithmetic behind each.

Running this costs you fifteen seconds. Write the sentence, name the type, count n, answer the four remaining questions, read the row. What you get back is that your answer and the drill's answer and the checker's answer are the same answer. So when two of them disagree, it tells you something about one of you. It's never a matter of taste.

Advertisement

Part of the course

This page is part of Chart-Choice Grammar: Match the Chart to the Message (PR2.01), in Phase 2: Financial statement analysis and quality of earnings. The module's flashcards and its quiz are in the app.