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:
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