Chart Graph in 2000

[Jane Collins]

I have two tables with different data but need to produce a graph that shows both tables as a comparison.

I can produce the chart with one table but don't know whether I can merge the second table.

Although you can use the SERIES in Excel is it possible to do something similar in Access 2000?

 

[Mikilu]

You can create a select query using the two tables and base your chart on the query. That way you get data from both tables on your query level. I don't think you can join charts to more than one table or query. Good luck.