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: