By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,390 Members | 2,050 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,390 IT Pros & Developers. It's quick & easy.

MS graph changing min and max axis values

P: n/a
Hi

I am manipulating MS Graph and can successfully change the minimum and
maximum values for the Y axis, but can't find a way of doing this for the X
axis.

This works for Y axis
graph1.Axes(2).MinimumScale = 100

I have tried other indexes but no luck. Can't find any good documentation on
this either.

Any clues.

Jeff
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Jeff wrote:
Hi

I am manipulating MS Graph and can successfully change the minimum and
maximum values for the Y axis, but can't find a way of doing this for
the X axis.

This works for Y axis
graph1.Axes(2).MinimumScale = 100

I have tried other indexes but no luck. Can't find any good
documentation on this either.

Any clues.

Jeff


Do a search on the MS web site for the MSGraph VBA programming help file
:)
--
regards,

Bradley
Nov 13 '05 #2

P: n/a
Tried that. Could only find info on changing the Y axis.

Jeff

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:40**********@news.melbourne.pipenetworks.com. ..
Jeff wrote:
Hi

I am manipulating MS Graph and can successfully change the minimum and
maximum values for the Y axis, but can't find a way of doing this for
the X axis.

This works for Y axis
graph1.Axes(2).MinimumScale = 100

I have tried other indexes but no luck. Can't find any good
documentation on this either.

Any clues.

Jeff


Do a search on the MS web site for the MSGraph VBA programming help file
:)
--
regards,

Bradley

Nov 13 '05 #3

P: n/a
On Fri, 04 Jun 2004 07:59:54 GMT, "Jeff" <je************@asken.com.au>
wrote:

Be sure this is an X-Y graph, not a kind of graph that has a static
X-axis.

-Tom.
Tried that. Could only find info on changing the Y axis.

Jeff

"Bradley" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:40**********@news.melbourne.pipenetworks.com ...
Jeff wrote:
> Hi
>
> I am manipulating MS Graph and can successfully change the minimum and
> maximum values for the Y axis, but can't find a way of doing this for
> the X axis.
>
> This works for Y axis
> graph1.Axes(2).MinimumScale = 100
>
> I have tried other indexes but no luck. Can't find any good
> documentation on this either.
>
> Any clues.
>
> Jeff


Do a search on the MS web site for the MSGraph VBA programming help file
:)
--
regards,

Bradley


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.