?
Solved

Second x Axis in an Access Graph

Posted on 2006-11-05
5
Medium Priority
?
313 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

777 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