View Full Version : One Chart - 2 Queries as Series


bg18461
06-11-2009, 11:03 AM
I am trying to graph 2 series of data the each pull from different queries onto one chart. Access makes it difficult to have two different queries as two different series on the same graph. Is there a way I can combine these two different criterias for on the same query.

So for each month, there will be 2 fields of data, one field is 1-12 Months, and the second field is 13-24, any ideas so I can graph it like this?

bg18461
06-11-2009, 03:31 PM
Please can anyone help, please see the attached image, I am trying to create these graphs, but this question is about the top graphs

Singlespeed
06-19-2009, 01:33 AM
Simple...

Just create another query based on the 2 queries you already have and join them on the month Field, then just show one month field and the data fields from each sub query, then use this "Parent" query. Make the graph and lines on 2 axis type so you will have revenuse on the left Y and KWH on the Right Y axis