Change graph to 100% maximum

  • Thread starter Thread starter Chuck W
  • Start date Start date
C

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
 
Goto the bottom left corner of your macro where the 0 is for the axis
scale>right click>format axis>scale>change as desired.
 
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.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 
Back
Top