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@gmail.com - 18 Sep 2006 20:00 GMT
> In Excel, when setting the x axis values from a macro one can set the
> value scale using
[quoted text clipped - 4 lines]
> 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