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.

DOWNLOAD EXCEL WORKBOOK

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Related Excel Tutorials