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