Solved

Switch xy scatter graph axes

Posted on 2002-03-23
7
1,045 Views
Last Modified: 2012-06-21
I've made an xy scatter chart in an Access report that would be absolutely perfect if the axes were switched. Is there an easy way to do this?

The chart consists of the following fields:

DepthTo   Fines   Gravel   LabFines   LabGravel
(feet)     (%)      (%)       (%)        (%)

Depth needs to be the y-axis. Right now on my chart depth is the x-axis. If only I could rotate the chart 90 degrees!

I have easily done these graphs in Excel but can't seem to do them in Access.
0
Comment
Question by:susyh
[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
  • 4
  • 3
7 Comments
 
LVL 54

Expert Comment

by:nico5038
ID: 6892185
When you select the graph with a right-click, you'll be able to select GraphicObject/Update.
When this is active you'll see a new menu with a button for row or column. I guess those buttons do what you need....

Nic;o)
0
 

Author Comment

by:susyh
ID: 6894485
Do I select the graph in design view? I can't see Graphic Object/Update.

I've played with rows vs. columns in the Microsoft Graph format area with no luck. If I have more than two columns of data I can't seem to switch the axes.
0
 
LVL 54

Expert Comment

by:nico5038
ID: 6894581
Just right-click the graph to get the pop-up window that also allows you to see the properties (last option).
The "Object" should be the second option and show two (or three) options to the right like "Open/Update" when selected. (I have the dutch version, so my translation can differ...) You should just get the Update window where the Rows/Cols buttons show, and also the (updatable) grid.

Clear as mud ;-) ???

Nic;o)
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:susyh
ID: 6894722
I'm sorry to be so stupid...the only "Update" I see on my properties dialog box is "Update Options - Automatic or Manual. It's the fourth choice on the "All" tab. I think we're looking at different things?

If you mean edit the graph itself I do that by double-clicking on the graph to access the actual datasheet and chart in MS Graph. I've tried many many things - rows vs. columns, changing the order of my underlying query fields, adding blank fields, adding duplicate fields. It's just beyond my grasp.

I want depth to be the y axis and several fields from one or more tables to be graphed for that depth. It's when I have more than one field of data to be plotted that I run into trouble.

Thanks  
0
 
LVL 54

Accepted Solution

by:
nico5038 earned 200 total points
ID: 6895097
Can you drop me the compacted and zipped database, so I can give it a try?
(Click my name for the emailaddress)

Nic;o)
0
 

Author Comment

by:susyh
ID: 6895311
Thanks. I'll do that.
0
 
LVL 54

Expert Comment

by:nico5038
ID: 6899573
Thanks suzyh,

Just hope you have more luck with these OLE graphs, as I once had to rebuild all my reports from scratch as the access graph stopped working... ;-(

For those interested in the solution, the embedding of an excel graph Using Insert/Object/New excel graph offers an OLE object with the excel possibilities.

Success with the application !

Nic;o)
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

739 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