Lesson 9 of 15 · Concept

How to choose the right chart for your question

Choose a chart by the question it has to answer: bars compare amounts, lines show change over time, a single number answers "how much", and a table gives exact values. A chart answers one question well. A second question usually needs a second chart.

From question to chart
QuestionUseWatch out for
How much in total?A single numberGive it a period and a comparison
Which is bigger?Bars, sortedStart the axis at zero
How did it change over time?A lineShow missing periods as gaps
What share of the whole?A stacked bar, or a pie with few slicesParts must really add up to the whole
Do two measures move together?A scatter plotMoving together doesn't show cause
What is the exact value?A tableToo many rows for a quick read

Match each question to a chart

Max Thrust, founder of fictional Vandelay Coffee Supply, is placing one hire in North or South. The table behind his Q3 decision is settled, and he has three questions.

How much? Who leads? Since when? Match each to a single number, two bars or a line over time.

How much is a single number, because nothing is being compared. Who leads is two bars, because length compares well. Since when is a line, because only position over time can show a change of lead.

One dataset, two charts, different answers

The bars answer the second question.

Who leads?

North
€5,578
South
€5,900
Net value at the end of Q3, in euros. Accurate, and it doesn't say when the lead began.

The line uses the same invoices and answers the third.

North led until September 23. South's lead comes with Initech's second invoice. Nothing on the bars hints at that, and it's the most useful fact about this hire so far.

Be careful what you claim from it. The line shows when the lead changed, and it can't show why, or whether South's market will keep growing. One new customer arrived and placed two orders. That's a fact about timing, and a reason to ask questions.

Zero baselines and truncated axes

A bar's length stands for its amount, so a bar chart needs an axis that starts at zero. Bars of 90 and 100 on an axis starting at 80 look like one is twice the other, when the real gap is about a tenth.

A line is read by its slope and position, so it can start above zero when the change is what matters. Say so on the axis. A tight range makes small wobbles look dramatic.

Missing periods are different from zero

Sales of 40 in January, nothing recorded for February and 50 in March can mean two things. If the shop was closed, February is a real zero. If the February file never arrived, it's unknown. A line joining January to March hides the question, and a drop to zero answers it wrongly.

Show an unknown period as a gap, and a known zero as zero. Excel makes the choice explicit, under Hidden and Empty Cells, as gaps, zero or a connecting line. A date dimension, from the star schema lesson, gives a report every period to fill.

Common chart mistakes

  • No unit or period in the label. Name the measure, the currency and the dates.
  • A random category order. Sort bars by value, unless the categories have a natural order.
  • Implying precision. Round to what the data supports.
  • A busier chart instead of a second one. Two measures on two axes let you draw almost any conclusion.

To chart your own export, try Vista, Oplema's browser app for dashboards, with no account needed.

Next, the dashboard lesson puts these answers on one page, in the order they'll be asked.