We help IT Professionals succeed at work.

# Second x Axis in an Access Graph

on
Medium Priority
342 Views
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

## View Solution Only

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

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.

##### Thanks for using Experts Exchange.

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