MS Access 2000 can't do x-y charts? (should be easy!!)

[nowanda]

Howdy!

Maybe I fell off the idiot tree and hit every branch on the way down but how on earth do you make a scatter plot using the infernal MS Graph in MS Access 2000?

breaking it down simply - a table with the following:
x y
1 11
2 12
3 13
4 14
5 15

Then I 'Insert Chart', Choose my x-y table, Choose my x-y fields, Choose the XY (Scatter) Chart, Put the x on the x axis and the y on the y axis.

If I then click 'Preview Chart' it comes up with exactly what I expect - Hooray!

However I choose Next.. Finish and I get a chart with all of my x values (1,2,3..5) in the legend and all of the y values over the x axis label 1. What gives?

It probably has to do with the fact that this is in the Properties of my miserable graph:
Row Source Type: Table/Query
Row Source:SELECT [x],[y] FROM [xy_test]; <--- shouldn't there be a TRANSFORM there?

Would anyone like to try this out and tell me if they get the same thing? (or hopefully tell me why my mean Access doesn't want to do what I would like?)

Thanks,
Nowanda

 

[nowanda]

Ok - I found a weird workaround for anyone else with the same issue - I'm sure that this is not the suggested way to go .. but it worked for me.

In MS Access 2000 - create your chart - but...
- choose a line chart instead of an x-y scatter
- completed the wizard with your line chart
- edit the 'Chart Type' and choose the x-y Scatter.

Voila! Your scatter is there and seems to work just fine!

I'm by no means an expert - so if anyone else can think of the reason why this was happening - feel free!

Nowanda