Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Switch xy scatter graph axes

Posted on 2002-03-23
Medium Priority
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 ;-) ???

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.


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

Independent Software Vendors: 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

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…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

610 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