y axis

[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

 

[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

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