Switch xy scatter graph axes

Posted on 2002-03-23
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.
Question by:susyh
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
LVL 54

Expert Comment

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....


Author Comment

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.
LVL 54

Expert Comment

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 ;-) ???

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)


Author Comment

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.

LVL 54

Accepted Solution

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)


Author Comment

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

Expert Comment

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 !


Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

756 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