All lessons

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:

When a table beats a chart

2025 sales and target by store

StoreSalesTargetvs 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 people need to look up exact values (store managers checking their own line), a small table is clearer than a chart. Right-align numbers and use the same number of decimals.

When you want to compare shapes, small multiples work better than one tangled chart:

Small multiples

Each category has its own season (2025, by month)

Electronics

05k10k15kJAJO

Home

05k10k15kJAJO

Outdoor

05k10k15kJAJO

Grocery

05k10k15kJAJO
Four small charts on the same scale instead of four tangled lines in one. Outdoor peaks in summer, Electronics at Christmas, Grocery stays flat. Monthly split shared out from each category's total using the data's season pattern.

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

  1. Each store manager wants to check their store’s sales, target and % vs target. Chart or table?
  2. You have 10 products’ monthly trends. One chart or small multiples?
  3. Small multiple panels each have their own y-axis scale. What’s the risk?
Answers
  1. A table (one row per store), maybe with conditional colour on the % column.
  2. Small multiples, sorted by total sales, with the same scale.
  3. 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

1When is a table better than a chart?
2What are small multiples?
3Why must small multiples share the same scale?

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.