Add Data Labels for Total to Stacked Columns in #Excel

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:

Excel Tips - Add data label of total to stacked columns

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.

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

Hope you like it. 🙂

Advertisements

About MF

An Excel nerd who doesn’t work on Excel most of the time at current job...... 🤔 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Chart and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.