I have a report in which I am including a XY scatter plot (see attached screenshot).
My data in the "Row Source" property query of the chart is setup as:
Station Elevation
0 10
2 5
4 15
6 20
and so on...
The chart seems to be taking each row of data as a new XY series (so there would be 4 series each with one point using the above data as an example). It should be creating a chart with one series (having 4 XY points using the above data as an example). I figure this has something to do with Access incorrectly recognizing the x-axis variable because every series starts at 1 instead of the actual station value.
What am I doing wrong??? I feel like I am missing something simple in order to make this work right. Any help is appreciated, Thanks, Jodi
Full Version: Xy Scatter Plot In A Report
QUOTE (jodidew @ May 9 2012, 11:44 AM) 
I have a report in which I am including a XY scatter plot (see attached screenshot).
My data in the "Row Source" property query of the chart is setup as:
Station Elevation
0 10
2 5
4 15
6 20
and so on...
The chart seems to be taking each row of data as a new XY series (so there would be 4 series each with one point using the above data as an example). It should be creating a chart with one series (having 4 XY points using the above data as an example). I figure this has something to do with Access incorrectly recognizing the x-axis variable because every series starts at 1 instead of the actual station value.What am I doing wrong??? I feel like I am missing something simple in order to make this work right. Any help is appreciated, Thanks, Jodi
My data in the "Row Source" property query of the chart is setup as:
Station Elevation
0 10
2 5
4 15
6 20
and so on...
The chart seems to be taking each row of data as a new XY series (so there would be 4 series each with one point using the above data as an example). It should be creating a chart with one series (having 4 XY points using the above data as an example). I figure this has something to do with Access incorrectly recognizing the x-axis variable because every series starts at 1 instead of the actual station value.What am I doing wrong??? I feel like I am missing something simple in order to make this work right. Any help is appreciated, Thanks, Jodi
Jodi,
Where is this data regarding "every series starts at 1 instead of the actual station value?" Is this a Pivot Chart?
The data is in the Row Source property which is a query bascially with the two variables Station and Elevation. I did not setup any pivot chart (well unless Access did this automatically)
Sorry for taking forever in getting back to you...
In order to get what you wanted I viewed the Report in Design, double-clicked on the Report. Then I had to change the chart so it was viewed "By Column". This changed how everything was showing in one vertical line you described. And you are correct, you should only need two Fields.
If you still need help, let me know and I can upload a copy. I don't have Access 2010, otherwise I would ask you to upload a copy of your dbase.
RAZMaddaz
In order to get what you wanted I viewed the Report in Design, double-clicked on the Report. Then I had to change the chart so it was viewed "By Column". This changed how everything was showing in one vertical line you described. And you are correct, you should only need two Fields.
If you still need help, let me know and I can upload a copy. I don't have Access 2010, otherwise I would ask you to upload a copy of your dbase.
RAZMaddaz
Awesome! That worked. I figured it was somthing simple I was missing. Thanks so much
Awesome too!!!! Glad I could help!!!
RAZMaddaz
RAZMaddaz
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.