ChartPaste

Guide

When a table is better than a chart

A chart is a tool for seeing a pattern. When the reader needs exact values, or there are only a handful of numbers, a table does the job better — and sometimes the right answer is no chart at all.

Updated November 8, 2026

The default in many reports is “add a chart”. But a chart and a table answer different questions: a chart shows shape — up, down, clustered, spread out — while a table shows values — the exact numbers, in a form the reader can look up. Using one where the other belongs is the quietest way to make a report harder to read.

Use a table when…

There are only a handful of numbers

Five values in a bar chart is three elements of decoration around what could be one sentence. “Revenue was 120, 138, 156 and 149 over the four quarters” is clearer than a chart with four bars.

The exact value matters

Charts are for relative comparison; readers cannot reliably read a bar to the nearest unit. Prices, budgets, contract values and financial statements belong in a table — or in a table next to a chart, with the chart carrying the trend and the table carrying the numbers.

The units or dimensions differ

A table can hold percentages, currencies and counts side by side without pretending they share a scale. A chart cannot: mixing units on one axis makes one of them invisible, and a second axis invites false comparisons. If the reader needs to scan several measures together, a table is the honest container.

The reader needs to look something up

A table is searchable and scannable by row; a chart is not. When the job is “find the value for March”, a table wins. When the job is “see whether March is unusual”, a chart wins.

Use no chart when…

  • There is one number. A single bar, a single point or a 100% pie with one slice shows nothing that the sentence does not.
  • The data cannot show a pattern. Three points do not establish a trend, and a bar chart of two categories is a comparison the reader can do in their head.
  • The comparison is not valid. Different denominators, no baseline, or a cherry-picked time window — a chart makes a questionable comparison look authoritative. Fix the data first; the reading guide lists the checks.

A worked comparison

A quarterly report wants to show four regions and their revenue, growth and margin. One chart cannot carry three measures and four regions without becoming unreadable. Two options work:

RegionRevenueGrowthMargin
North$1.2M+8%31%
South$0.9M+14%27%
East$0.6M−3%19%
West$0.4M+2%22%

The table carries the values. If the meeting is about the pattern, add one chart for the measure that matters — for example, growth by region as a bar chart — and let the table hold the rest.

A decision checklist

  1. Does the reader need the exact number, or the shape of the data?
  2. Are there enough values for a shape to exist?
  3. Do all the values share a unit and a scale?
  4. Will the reader look values up, or compare them at a glance?
  5. Is the comparison valid before it is visualised?

If the answers point to a table, use a table — and if a chart is still useful next to it, make the chart carry one idea, not all of them. The chart-choice guide covers the other half of the decision: which chart, once a chart is the right answer.

Want to try this with your own data?

ChartPaste turns a pasted table into 20 chart types — free, no sign-up, and your data never leaves your browser.

← All guides