Stacked Column chart Y axis goes to 120%!

[danprhayes]

I dont want my chart to go to 120% since any value will only go to 100%. Excel makes the graph look silly and not best use of space..

I have tried changing the format axis values (min,max etc) but not working

Please help

 

[RalphA]

As long as no value exceeds 94.23%, you should not have this problem.

However, to make the axis values go from 0 to 100%, just right click the values in the % axis, then click on Scale, and change the Max value to 100.

I don't know why you say it didn't fix your problem to cange the Max value. Please try again, and, if it doesn't work, report what you did and what you got. And, do tell us if this fixed your problem.