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:
- Create a stack columns, of course
- Exclude the Total data row
- Add data labels to the chart
- Create a “Dummy” series of data, say 10 (any reasonable value that results in a visible stack columns on the top)
- Add that “Dummy” data series to the stacked columns
- Format the Data labels for the added “Dummy” series
- Select “Value from Cells” under Label Options
- Reference to the original total row
- Set the “Dummy” series to 0
- 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. 🙂