Multiple field of same record in a graph. You have experience?

[accessuserit]

I have a query that build two series of value
(quality1,price1),(quality2,price2), (quality3,price3), ...
for example(95, 82),(97, 88),(96, 84)

i need to compose a sigle graph with on X axis the quality value, and on y axis the price values of each groups.

if i use only two values or one group(quality1,price1) do not have a problem

if i try to use 4 or more values (two or more groups of data) dont work

In need another help to create a tendence line on the same graph.

Help me
Tanks for your time!

Paul Chiesa - iamayrton@yahoo.it

 

[genomon]

Chart tool might work if based on a query that groups quality and price. The x-axis value would have to contain all present values for quality and y-axis would be price (of course). The trick is the grouping in the query used as the recordsource for the chart. Check out help on the crosstab query wizard, especially if these needed to be charted over time...