Want to know how to create a 100% Stacked Column Chart with Excel?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch on YouTube and give it a thumbs up 👍

The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total.

For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then this is the chart for you.



STEP 1: Select the table on where we want to create the chart on.  

Excel Stacked Column chart


STEP 2: Go to Insert > Column > 100% Stacked Column 

Excel Stacked Column chart


Your chart is now ready:

Excel Stacked Column chart


Excel Stacked Column chart

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