We help IT Professionals succeed at work.

Second x Axis in an Access Graph

quickdan
quickdan asked
on
Medium Priority
342 Views
Last Modified: 2012-05-05
Hi,
I have a line graph with two statistics.
Say "Number of Sales" and "Value of Sales".
I can happily code the maximum and minimum scales for the first statistic (Left hand side).
and am using:
Me![Graph0].Object.Application.Chart.axes(2).minimumscale = _
          CDbl(Me.Min1) 'Set the minimum scale
      Me![Graph0].Object.Application.Chart.axes(2).maximumscale = _
          CDbl(Me.Max1) 'Set the maximum scale
But I'm having trouble identifing the second (Right hand side) x axis.
I've tried .axes(3), .axes(4) and .axes(1) and by doing so really messed up the graph.
I got it back again working as before the trail and error testing - actually all error testing.

My question is does anyone know how to reference the second x axis for maximum and minimum scales?
Or where I could go to find out?

Thanks
Danny

Thanks
Comment
Watch Question

Author

Commented:
Oh, by th way it's called "Secondary Value Axis".

Author

Commented:
Well, I've answered my own question

Me![Graph0].Object.Application.Chart.axes(2,2).minimumscale = _
          CDbl(Me.Min1) 'Set the minimum scale
      Me![Graph0].Object.Application.Chart.axes(2,2).maximumscale = _
          CDbl(Me.Max1) 'Set the maximum scale

I guess you can close the ticket.

Danny

Commented:
Grats! Well done! Now you can read...

I answered my question myself. What do I do? {http:/help.jsp#hi70}

Cheers!
(°v°)
Commented:
Closed, 250 points refunded.
PashaMod
Community Support Moderator

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.