Chart Without AutoCalc

[rgkdlsie]

I have a query which I would like to simply graph as an X-Y graph, no calculation (sums, average, etc) necessary. How I disable the pivotchart from trying to sum and average everything?



Example data:
X Y
1 3
2 4
3 3
4 2

I would like to make a graph with a point at (1,3) another at (2,4), another at (3,3) and another at (4,2). I feel like this should be a simple problem but I can't figure out how to stop the pivot chart trying to "help" me by averaging or counting or summing everything. Thanks for the help.

[June7]

The X and Y are fields of table? Use a SELECT sql in the graph RecordSource property, like:
SELECT x, y FROM tablename;

The first field in the sql will plot as x, other fields will plot as y.