The result is a chart that shows a proportional breakdown of each quarter by region.
Looking at the chart, you might wonder how to show the actual percentages in each bar?
This isn’t hard to do, but it does take a little prep work.
But there is an option to pull values from other cells.
To start off, I’ll copy and paste the whole table and remove the values.
In other words, I need to divide C5 by the sum of C5 to F5.
F4 three times will do the job.
Now when I copy the formula throughout the table, we get the percentages we need.
Now we have a 100% stacked chart that shows the percentage breakdown in each column.
Whenever you create these kind of helper calculations for a chart, take care with the Switch Column/Row button.
To fix this problem, I would need to update the formulas in the helper table.
