Group:  Microsoft Excel ยป microsoft.public.excel
Thread: y axis

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

y axis
gw.boswell[ at ]gmail.com 18.09.2006 15:17:20
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

Re: y axis
gw.boswell[ at ]gmail.com 18.09.2006 19:00:11

gw.boswell[ at ]gmail.com wrote:
[Quoted Text]
> 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

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net