When we create stacked columns in Excel, we exclude Total from the data as it may give an extra stack that we don’t want.  However, we may want a data label for Total on the stacked columns, like the one below:

So how can we do that?  This is what I am going to show you in a short video.

You may download a Sample File to follow along.

In short, the following steps applied:

1. Create a stack columns, of course
2. Exclude the Total data row
3. Add data labels to the chart
4. Create a “Dummy” series of data, say 10 (any reasonable value that results in a visible stack columns on the top)
5. Add that “Dummy” data series to the stacked columns
6. Format the Data labels for the added “Dummy” series
7. Select “Value from Cells” under Label Options
8. Reference to the original total row
9. Set the “Dummy” series to 0
10. A bit of formatting…

That’s it! 🙂

Please see the step by step demonstration in the following video.

In case you want a Cantonese video:

Please subscribe to the channel and hit the bell in order to get notification for new videos.

Hope you like it. 🙂