Change graph to 100% maximum

[Chuck W]

I have a graph with some values at 100%. The graph goes up to 120%. I would
like to change to top line to 100% but can't figure out how to do this. Can
someone help?

Chuck

 

[Don Guillett]

Goto the bottom left corner of your macro where the 0 is for the axis
scale>right click>format axis>scale>change as desired.

 

[DILipandey]

Hi Chuck,

Double click on the Y- axis of the graph and type in the value as 1 against
Maximum Field.

Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
[email protected]
[email protected]
New Delhi, India