Archive of Mr Excel Message Board

I have a problem about changing axis scale of chart with
logarithmic scale. Actually, after applying logarithmic scale,
the Y-axis interval includes 1, 10 &100. However, the largest Y-
value is only 11 and thus there is plenty of empty area above
the highest point. I have tried to change "maximum" text box
in "format axis" window to 20 and uncheck "auto" check
box, "maximum" changes back to 100 automatically.

How can i change the maximum Y-axis value for logarithmic scale
chart to number that is not exponential of 10?

thx!!!!