Dynamic graphs

[tractorvix]

Hi All,

I hope you'll be able to help me. I'm running MS Access 2000 and want to be able to achieve the following:
Customer to be able to select 'product'
Customer to be able to select x and y variables (these variables will be the same for all 'products')
Customer to be able to select 'view graph' and see the 2 variables plotted on a x,y scatter graph with a line of best fit.

I'm unsure of best format for my data whether to have all variables for each 'product' grouped in a table
OR
single variable tables for each product (which seems like the right way to do it to me)
I've got about 300 data points for each product variable.
So I guess I've a few questions!
1 - what would you suggest as the best way to group my data to make pulling the relevant information out most easy?
2 - I'm happy to set up the drop down boxes to select the graph criteria, but then do I need to set up a query to feed a graph?
3 - I've not used the graph function before in a report (other than a static graph based on a query, with pop up filtering), so some guidance on this would be ace.

Thanks all.

TV