• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1066
  • Last Modified:

Switch xy scatter graph axes

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
susyh
Asked:
susyh
  • 4
  • 3
1 Solution
 
nico5038Commented:
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
 
susyhAuthor Commented:
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
 
nico5038Commented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
susyhAuthor Commented:
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
 
nico5038Commented:
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
 
susyhAuthor Commented:
Thanks. I'll do that.
0
 
nico5038Commented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now