Solved

Second x Axis in an Access Graph

Posted on 2006-11-05
5
267 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
0
Comment
Question by:quickdan
  • 2
5 Comments
 

Author Comment

by:quickdan
ID: 17878333
Oh, by th way it's called "Secondary Value Axis".
0
 

Author Comment

by:quickdan
ID: 17879261
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
0
 
LVL 58

Expert Comment

by:harfang
ID: 17970284
Grats! Well done! Now you can read...

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

Cheers!
(°v°)
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 18193303
Closed, 250 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now