Access Graphing - Independent Axis

[bobbyba]

Hi Everyone,

I'm having some problems with graphing data. Using an xy scatterplot the x-axis is by default the independent axis and the various series are plotted on the y-axis.

I would like to be able to use the y-axis as the independent axis and plot various sets of data along the x-axis. Is there any way of changing the independent axis to the y-axis? or is there a yx scatterplot chart option?

 

[llkhoutx]

Yes, all one does is change the recordsource for the chart.

[This message has been edited by llkhoutx (edited 06-03-2002).]

 

[jared5]

How do I change the recordsource for the chart so that the y-axis becomes the category axis and numerous fields can be plotted against this y-axis?

In Excel graphing what I am trying to graph is simple (XY Scatterplot Chart), for each series the x-axis and y-axis can easily be chosen...But in Access I can not figure out how it works. Is there a way in Access to manually program several series to graph..where you can separately choose the x-axis and y-axis of several series and then plot them all on the same graph?

I want to graph various data versus depth in the ground...so I want depth on the y-axis and several fields plotted against depth.

 

[llkhoutx]

Switch the columns being charted in your recordsource.