Add Total Labels to a Stacked Bar or Column Chart in Excel

This is one of the oldest gaps in Excel charting. You build a stacked column showing four product lines per quarter, everyone can see the segments, and the first question in the meeting is “what does that column add up to?” Excel will happily label every piece and nothing at all for the whole.

There is no setting to turn on. But there is a reliable trick, and once you know why it works you can adapt it to any stacked chart.

Step one: add a totals column

Whatever method you use afterwards, it starts here. If your data sits in B2:E13 with categories in A, put this in F2 and fill down:

=SUM(B2:E2)

Select B2:E2 and press Alt+= if you would rather Excel wrote it — that is what AutoSum is for.

Column F is now a helper column. It has to exist on the sheet for the chart to read it, but it does not have to be visible or ugly. If it sits in the middle of a report, the three-semicolon custom format will hide the values without hiding the column, and the chart still reads them perfectly.

Method 1: the invisible line series (stacked column charts)

This is the cleanest result for vertical stacked columns, because the labels sit neatly above each column with a little breathing room.

1. Add the totals to the chart. Click the chart, then Chart Design → Select Data → Add, and point the series values at F2:F13. The columns will suddenly double in height — that is expected, and the next step fixes it.
2. Change that series to a line. Right-click the new segment → Change Series Chart Type. In the combo list, set only the Total series to Line and leave the others as Stacked Column. The total now floats at the top of each stack instead of adding to it.
3. Make the line disappear. With the line selected, open Format Data Series → Fill & Line and set No line, then Marker → None.
4. Label it. Select the invisible series, choose Add Chart Element → Data Labels, and set the position to Above.
5. Tidy the legend. Click the legend, click the “Total” entry on its own, and press Delete. That removes the entry without removing the series.

The reason this works: a line series is not part of the stack, so it contributes no height. It is plotted at the value of the total, which is exactly the top of the column, and its data label is anchored there.

Method 2: zero values and Values From Cells (works on bar charts too)

Horizontal stacked bar charts cannot be combined with a line series, so Method 1 is unavailable. This one works everywhere.

1. Add a helper column of zeros next to your totals — put 0 in G2 and fill down.
2. Add G2:G13 to the chart as a new series. It stacks on the end and takes up no space, because every value is zero.
3. Give it no fill. Format Data Series → Fill → No fill. There is nothing to see anyway, but this stops a stray outline appearing.
4. Add data labels to that series, then right-click a label and choose Format Data Labels.
5. Point the labels at your totals. Under Label Options → Label Contains, tick Values From Cells. When the Data Label Range box appears, go back to the sheet and select F2:F13. Untick Value so the zeros do not show alongside.

The zero-height segment sits precisely at the end of the stack, so its label lands where the total belongs. Values From Cells then displays whatever is in column F rather than the series value.

Values From Cells is available in Excel for Windows from Excel 2013 onward. On older builds, Method 1 is your only automatic option.

Which method to use

Method	Works on	Updates with the data	Effort
Invisible line series	Stacked column (vertical) only	Yes	Five clicks; best-looking result
Zero series + Values From Cells	Stacked column and stacked bar	Yes	Slightly fiddlier; Excel 2013 and later
Values From Cells on an existing segment	Any stacked chart	Yes	Fastest, but the total sits inside the top segment
Text boxes typed by hand	Anything	No	Avoid — wrong the moment a number changes
Chart title showing a grand total	Anything	Yes, if linked to a cell	Only useful for one overall figure, not per bar

The third row is worth knowing about when you are in a hurry: you can label the topmost existing segment with Values From Cells pointing at the totals column. It takes thirty seconds. The total then appears inside the top block rather than above the bar, which is less readable but perfectly honest.

What goes wrong

The chart doubled in height. You added the totals as a stacked column series and stopped there. The total is being stacked on top of the values it summarises. Change it to a line (Method 1) or use zeros (Method 2).

The labels show 0. In Method 2 you ticked Values From Cells but left Value ticked as well. Untick Value.

New rows do not appear in the chart. The chart is pointing at a fixed range. Convert the source to a Table with Ctrl+T before you build the chart and it grows by itself — the same problem, and the same fix, as adding new data to an existing chart.

Labels collide with the plot area edge. Give the value axis a slightly higher maximum, or set the label position to Above and reduce the font size. Stacked bar charts often need a wider plot area rather than a taller one.

You want the helper columns gone. They cannot be deleted — the chart reads them live. Hide them, move them to a far-right block, or put them on a separate sheet and point the series there. If a workbook has accumulated abandoned attempts, deleting all the leftover charts at once is quicker than clicking each one.

Frequently asked questions

Sources