Graph Y-Axis Scale

ezpc

Registered User.
Local time
Today, 18:08
Joined
Sep 7, 2000
Messages
19
I have a graph that shows about five grouped fields displayed as percentages. I would like to have the y scale go from 1 to 100%. Even if I try to manually adjust the scale maximum to 100%, it won't stick. Say, the numbers vary from 5% to 18%, it will only display the maximum as 18%. Scratching my head...
 
In design view, double click on the graph and graph app will open. Right click on one of the Y Value labels and you will get format axis. On the Scale tab, change the maximum to 1(if you are working with %) and UNCHECK the auto box on the left of the Maximum label.

HTH
 
Yesss! Thanks so much Harry. That's just what I wanted.
 

Users who are viewing this thread

Back
Top Bottom