y axis

  • Thread starter Thread starter gw.boswell
  • Start date Start date
G

gw.boswell

In Excel, when setting the x axis values from a macro one can set the
value scale using
Axes(xValue).minimumscale = 11111. I also need to set the scale on the
y axis. Excel calls the y axis something odd and I can't remember or
find it. Can someone remind me of that correct syntex.

TIA
Garry
 
In Excel, when setting the x axis values from a macro one can set the
value scale using
Axes(xValue).minimumscale = 11111. I also need to set the scale on the
y axis. Excel calls the y axis something odd and I can't remember or
find it. Can someone remind me of that correct syntex.

TIA
Garry
Click to expand...

Obviously I reversed the X and Y labels. It is the Y axis that is
called xlValue and I finally found the X axis label - xlCategory.
Sorry for the mix up and unnecessary post.

Garry
 
Back
Top