Stacked columns: the parts and the total
Stack several series into one column per category, so a chart shows each total and what it is made of. Intermediate · 4 min · Stacked column chart, Series, Data labels
When a table has several columns of numbers, each one becomes a series in the chart, with its own colour.
By default a column chart puts the series side by side: good for comparing North with South in each quarter, but nobody can see the quarter's total.
A stacked column chart puts them on top of each other. Each column's height is the total, and its coloured parts show what the total is made of. One chart answers two questions: which quarter was biggest, and who contributed what.
In Excel, it's Insert → Charts → Column → Stacked Column. Here, insert a column chart and tick Stacked in the Chart panel.
Steps
Sales for three regions over four quarters. Select
A1:D5, click Chart, and insert a Column chart.Click the chart to select it: the Chart panel opens on the right (on a phone, tap Chart settings in the toolbar). Tick Stacked.
Put the numbers on the parts: tick Data labels.
Under Chart title, type Sales by quarter and region.
Remember
- Each column of numbers in the data is a series.
- Side by side compares the series; stacked shows the total and its parts.
- The bottom series and the totals are easy to compare. The parts in the middle are not.
- Keep to a few series, and put the most important one first.
Previous: Chart the summary, not the rows · Next: Highlight what needs attention