Budgeting

Stacked column charts hide what happens to the middle category

Why stacked column charts hide what happens to the middle category: only the bottom and top are easy to read. See a worked example and better alternatives.

Editorial illustration for Stacked column charts hide what happens to the middle category

In a stacked column chart, you can read the bottom category and the total easily, and the top category fairly well, but the categories in the middle are hard to judge because they float on top of whatever sits beneath them. Their height is accurate, but their position moves each month, so the eye cannot compare them. If you care about a middle category, plot it on its own.

Why is the middle so hard to read?

Comparing lengths is easy when bars start from the same line. In a stack, only the bottom segment starts from the same baseline every month. Every other segment starts wherever the segments below it end. So when the bottom segment grows, the middle one is pushed upward, and it looks as if it also grew, even when its size is unchanged.

What does that look like with numbers?

Take a hypothetical chart of three categories over four months, stacked with groceries at the bottom, eating out in the middle and travel on top.

MonthGroceriesEating outTravelEating out sits betweenColumn total
Month 1₹8,000₹4,000₹3,000₹8,000 and ₹12,000₹15,000
Month 2₹10,000₹4,200₹6,000₹10,000 and ₹14,200₹20,200
Month 3₹7,000₹4,500₹2,500₹7,000 and ₹11,500₹14,000
Month 4₹9,000₹4,800₹5,000₹9,000 and ₹13,800₹18,800

Eating out is quietly rising: ₹4,000, ₹4,200, ₹4,500, ₹4,800, which is a steady 20% rise over the period (₹800 ÷ ₹4,000). But the top edge of that segment sits at ₹12,000, then ₹14,200, then ₹11,500, then ₹13,800. It goes up, down, and up again. Someone reading the chart would say eating out was erratic. The steady rise is invisible, because the segment's position is dominated by groceries moving underneath.

What are the better options?

  • A line per category: each line has its own baseline, so trends are obvious. Use it when you have up to five or six categories.
  • Small multiples: one small chart for each category, all with the same vertical scale. You can compare shapes at a glance and the same scale stops one category from looking bigger than it is.
  • A table of figures next to a total-only chart: the total chart shows overall spending, and the table gives exact category numbers.
  • A clustered column chart: bars side by side from a common baseline. It works for two or three categories, but it gets crowded after that.

If you do keep a stacked chart, put the category you care about at the bottom, so its baseline is fixed, and put it first in the legend.

How do you rebuild the chart in a sheet?

  1. Put months down column A and one category per column to the right.
  2. Select the data and insert a line chart instead of a stacked column.
  3. If you prefer small multiples, make one small chart per category and set the same minimum and maximum on each vertical axis.
  4. Label the last point of each line with its value, so you do not have to read figures from the scale.

When is a stacked chart still fine?

When your main question is the total, with a rough idea of what it is made of. It is also fine when you have only two segments, because then the bottom one is readable and the top one is the total minus the bottom. The trouble starts at three or more, and gets worse with each extra category.

Where does a tracker fit?

If you want to compare a category month by month, filter for it. SpendixAI has a Report builder where you can filter and group your records, and a library of ready-made reports, so you can look at one category's monthly totals on its own instead of squeezing it into a stack.

A quick rule

  • Totals and the bottom category: stacked chart is fine.
  • Trends in the middle or top: use lines or small multiples.
  • Exact values: use a table.
SPENDIXAI JOURNAL

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

Explore your reports