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 ***
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.
STEP 2: Go to Insert > Column > 100% Stacked Column
Your chart is now ready: