Thread: 100% stacked column graph (incorrect proportions)

Good Morning,

Related to 100% stacked column graph
Workbook attached

I have two tables Table 1 & Table 2. if you see the attachment Table 1 graph proprtions for Mr. B'is not correct.

However if in table 2 I have adjusted the percentages for Mr. B and the graph shows correct proprtions.

please help

R

Hello,

in the upper chart, the Y axis starts at 80%. Column charts should ALWAYS be plotted against a Y axis that starts at 0. Format the Y axis and change the Minimum settings from "auto" to "fixed" and enter a 0.

cheers,