Module 2: Choosing the chart · Lesson 2.4 · about 10 min
Tables, cards and small multiples
Not every answer needs a chart. When a table beats a chart, when a single number card is enough, and how small multiples untangle a spaghetti chart.
Module 2 · about 10 minutes · read first: 2.2. You’ll know when to use a table, a single-number card or a grid of small charts instead of one big chart.
1. Why this matters
Analysts sometimes force everything into a chart. But a store manager checking their own number wants a table, a CEO wants one big number, and a buyer comparing seasonal patterns across categories wants small multiples. Picking the right format respects how the reader will use it.
2. The idea in one picture
When people need exact values, a well-formatted table is the clearest choice:
2025 sales and target by store
| Store | Sales | Target | vs target |
|---|---|---|---|
| Queen Street | $78,295 | $72,000 | +8.7 % |
| Falls Centre | $57,838 | $56,500 | +2.4 % |
| Rideau | $50,727 | $45,400 | +11.7 % |
| Harbour Front | $45,433 | $42,100 | +7.9 % |
| Forks Market | $30,178 | $30,300 | -0.4 % |
When you want to compare shapes, small multiples work better than one tangled chart:
Each category has its own season (2025, by month)
Electronics
Home
Outdoor
Grocery
3. Which format, when
| Format | Use when | Rules |
|---|---|---|
| Table | Readers look up their own row; exact values matter; mixed units | Right-align numbers, same decimals, light row lines, no heavy grid, highlight with colour sparingly |
| Card (one number) | One key number, such as total sales or margin % | Label with the period, add a comparison (Module 4) |
| Small multiples | Comparing the shape of the same measure across 3 to 12 categories | Same chart type and same axis scale in every panel; order the panels meaningfully |
| Chart | Seeing a pattern, ranking or trend | Modules 2 and 3 |
Principle
Principle: charts are for patterns, tables are for lookups. If the reader’s question is “what is my number?”, give them the number; if it’s “how do they compare?”, give them a picture.
Analogy: a train timetable (table: find your train) vs a route map (picture: see how lines connect). Both are useful; neither replaces the other.
4. Worked example
Four categories’ monthly sales in one line chart: four lines cross each other and the reader has to match colours to a legend. As small multiples: four panels, same scale. In seconds you see Outdoor peaks in summer, Electronics jumps at Christmas, Home is steady and Grocery is flat and small. That’s a stocking decision made easy.
5. Practice
- Each store manager wants to check their store’s sales, target and % vs target. Chart or table?
- You have 10 products’ monthly trends. One chart or small multiples?
- Small multiple panels each have their own y-axis scale. What’s the risk?
Answers
- A table (one row per store), maybe with conditional colour on the % column.
- Small multiples, sorted by total sales, with the same scale.
- A small product’s panel would look as big as the best seller’s; readers would compare the wrong thing.
Next, Lesson 2.5: how charts can mislead, even by accident.
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.