Budgeting

Truncated axis: how a spending chart exaggerates a small rise

A chart axis that starts above zero makes a small rise in spending look huge. See ₹46,000 to ₹48,000 drawn both ways, plus a rule for bar and line charts.

Editorial illustration for Truncated axis: how a spending chart exaggerates a small rise

A truncated axis is a vertical scale that starts above zero. It makes a small rise in spending look dramatic, because the bars or line are drawn relative to the new starting point instead of to nothing. A move from ₹46,000 to ₹48,000 is a rise of about 4%, but on an axis starting at ₹45,000 the second bar looks three times as tall as the first.

How can one rise look so different?

Take two months of spending, ₹46,000 and ₹48,000. The difference is ₹2,000, and ₹2,000 ÷ ₹46,000 is about 4.3%. Now draw the same two bars twice.

  • Axis starting at zero: the bars are 46 and 48 units tall. The second is about 4% taller, so the eye reads it as a small change, which it is.
  • Axis starting at ₹45,000: the bars are 1 and 3 units tall (₹46,000 − ₹45,000 and ₹48,000 − ₹45,000). The second bar is three times the first, so it looks like spending tripled.

Same data, two very different stories. Nothing about the money changed; only the baseline did.

Axis starts atHeight of ₹46,000 barHeight of ₹48,000 barHow much taller the second looks
₹046 units48 unitsAbout 4% taller
₹40,0006 units8 unitsAbout 33% taller
₹45,0001 unit3 units200% taller, or three times

Check the middle row: (₹46,000 − ₹40,000) = 6 and (₹48,000 − ₹40,000) = 8, and 8 ÷ 6 is about 1.33. The further the baseline moves up, the larger the visual exaggeration, even though the numbers are identical.

Why do charts do this?

Some charting tools choose an axis range automatically to make the data fill the space, and a range that is tight around the values can start well above zero. It is usually not deliberate, but it leaves you with a chart that feels alarming. Before you react to a steep line or a tall bar, look at the numbers on the left side.

What is the rule for bar charts and line charts?

  • Bar charts: start at zero, always. A bar's length is the value, so cutting off the bottom changes what the bar says.
  • Line charts: the axis may start above zero when the interesting variation is small compared with the totals, but the axis must be clearly labelled, and you should state the size of the change in plain numbers next to it.
  • Either type: if the story is a 4% rise, say "up about 4%" in the title or caption, so the shape of the chart cannot be mistaken for something larger.

How do you fix the axis in a spreadsheet?

In Excel and Google Sheets, open the axis options for the vertical axis and set the minimum to 0. In both, the setting sits in the chart's formatting or customise panel, though the menu names differ between versions. For a line chart, if you prefer to keep a tighter range, add a data label to the first and last points so readers see the actual figures.

Is a tight axis ever fine?

For line charts, yes, when you want to see small month-to-month movements and everyone looking at it knows the axis does not start at zero. Even then, give the reader the number as well, for instance "₹46,000 to ₹48,000, up ₹2,000". If your aim is to decide whether a rise is worth acting on, ₹2,000 against a ₹46,000 base is the useful fact, and the shape of the line is not.

When you read a trend, ask three things

  1. Where does the axis start?
  2. What is the actual change in rupees and in percentage?
  3. Is there a reason, such as a festival month, a premium due or a one-off purchase, that explains it?

If you track spending in SpendixAI, the same habit applies to its charts or any report you download as CSV and re-plot: read the scale first, then the shape.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports