A common question is “How can I label the total stack values in a stacked column chart?” When you add data labels to the chart, you can’t get any labels showing the totals.
Let’s use some simple data to illustrate.
Here is a standard stacked column chart.
When we apply data labels to the chart, we get a label for each column segment in the stack, but no labels for the total of each stack.
We only need to add a series to the chart that encodes the totals. Column E has the totals for each stack.
Construct the chart as a stacked column chart, with the Totals column stacked on top.
Change the Totals column series to a line chart type series.
Add data labels to the Totals series.
Move the labels to the Above position (right click on the labels and choose “Format” to open the format dialog).
Hide the Totals series by formatting it to show no lines and no markers. And don’t forget to delete the unwanted legend entry: click once to select the legend, click again on ‘totals’, then click the Delete key.
Nicely done, without being too sneaky: just one hidden series.