XY (Scatter) Chart

[jas580]

I have an very simple query that I want to use to create a scatter plot. I
can't get it even remotely close using the chart wizard and I can't figure
out how to manually create a chart. Every variation I've tried with the
wizard gives me the same East West North South nonsense with a datasheet that
seems to use random values. My query contains:

[Label], [xValue], [yValue]

That's it- I just want to plot the points! please help...

-Jeff

 

[Duane Hookom]

I just tried creating a chart like this. The key may be to open the chart in
design view and select Data->Plot on X Axis.

If you can't figure this out, come back with your Row Source.

 

[jas580]

No luck... It seems to use the first xValue as x and then all subsequent
xValues as y. It then does the same thing for the yValue field- first yValue
as x, all subsequent yValues as y. The datasheet looks like this (including
headers):

blank A B
[Label] [xValue] [yValue]
1 X A 99 37
2 shape B 276 29
3 shape C 523 44
4 shape D 264 31

My row source is just the query name. I've tried leaving it with the SELECT
statement in row source and it doesn't make a difference because the query
only has the three fields mentioned earlier.

I appreciate your help. I don't understand why this is so difficult.

-Jeff

I just tried creating a chart like this. The key may be to open the chart in
design view and select Data->Plot on X Axis.

If you can't figure this out, come back with your Row Source.
--
Duane Hookom
Microsoft Access MVP

I have an very simple query that I want to use to create a scatter plot. I
can't get it even remotely close using the chart wizard and I can't figure
out how to manually create a chart. Every variation I've tried with the
wizard gives me the same East West North South nonsense with a datasheet that
seems to use random values. My query contains:

[Label], [xValue], [yValue]

That's it- I just want to plot the points! please help...

-Jeff

 

[Carole Garrison]

I am having the same problem I use the wizard for a simple chart. It lets me preview it and it is fine. then I hit finish and I get this stupid N,S,W,E chart and all my data is wrong. I was just hoping you had figured it out.

Carole

 

[Egon Berghoffer]

im Newsbeitrag

I am having the same problem I use the wizard for a simple chart. It lets
me preview it and it is fine. then I hit finish and I get this stupid
N,S,W,E chart and all my data is wrong. I was just hoping you had figured
it out.

Carole
hi i am egon and i live in austria. where do you come from

 

[Duane Hookom]

You can copy the data from the datasheet view of your chart row source and
paste it into the datasheet in the design of the query. Not fun but it has
worked for me.