charts with data from more than one query

[Guest]

Is it possible to create a chart from data from more than one query or table?
I have figures for 3 years (in 3 seperate queries) and want to produce a
chart that displays averages for each month across all 3 years- e.g average
for jan, 2005, 2006 and 2007, feb 2005,2006 and 2007 etc.
I've tried by producing a new query to join the average columns for all 3
tables togeather, however am unable to do this as when i try to add a date
column, Access automatically formats the date to 2007 and so the query does
not display the averages for 2005 or 2006. Anyone know how I can get round
this problem? Any ideas are greatly appriciated!

 

[Arvin Meyer [MVP]]

I can think of several ways to do this, but my preferred way would be to
output 3 separate recordsets to 3 Excel ranges and build a chart in Excel.
Doing this will allow more leeway in the manner that I present the data. You
can use the OutputTo method or the TransferSpreadsheet method, or even use
automation as per the example at:

http://www.mvps.org/access/modules/mdl0006.htm