Adding total values to stacked column chartsAdd Total Values, Percentages & Dynamic Legends

 

There is so much potential to improve the standard Excel stacked chart. For one, adding total values outside the last stack would ease comparison between categories.

Adding percentages to the stacks would also help identify and compare the stack sizes to one another.

One method I specially like, is to create a dynamic legend and to put the labels of each of the stacks (so not the data labels but the name of the stack) on the right hand side of the last category – as shown in the graph below.

Step 1: How to add Total Values to Stacked Charts in Excel

Step 2: How to add Dynamic Series Labels (Excel Legend) for Improved Readability

Step 3: How to show Percentages in a Stacked Column Chart in addition to Values

Download the Workbook to follow along

Free download SUMIFS, SUMPRODUCT workbook example

The new Waterfall Charts course is here!

Now available on Udemy

Impressive Excel Waterfall Charts for your reports.
Redeem your coupon for 67% off below.

GET 67% OFF THE COURSE
Free Ebook