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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails


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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
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…

747 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

13 Experts available now in Live!

Get 1:1 Help Now