The Stacked Column chart is used in Excel to compare the contribution of a value to a Total.

For example, if you want to show the North & South sales for the last 5 years then this is the chart for you as I explain below.

NB: If you are using Years as your first column then you need to convert these to text by entering the apostrophe ‘ before the year.  If not, then it will simply include the Year value as part of the Totals.

Stacked Column Chart: Compare Contributions | MyExcelOnline



Helpful Resource:



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn