I have a chart with a column that totals up the individual columns. However, when I plot it on a bar graph, the vertical axis is always scaled with respect to the "Total" column and that greatly distorts and misrepresents the data.
A B C Total
Yes 10 27 50 87 : This chart will have a maximum value of ~87
No 20 18 7 45
A B C
Yes 10 27 50 : This chart will have a maximum value of ~50
No 20 18 7
How can I plot a bar graph scaled correctly? Thanks.