MS Graph - Scatterplot - Multiple X columns

[jflachman]

In Microsoft Excel, you can create a XY scatterplot with a column of X data for each column of Y data. This is especially useful when the various columns of Y data are taken at different X values.

I need to graph some test data. The X axis is Frequency, the Y axis will be distance.

Each test run may be run at different frequency ranges or with a different number of data points within the same frequency range, or both.

In Excel, this is really easy to deal with. In Access I am stumped. I have a form with a chart on it. I need to be able to chart various combinations of test data, regardless of the above variability.

Any clues?

Thanks in advance

Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt