Graph totals from two queries with different data

[maggioant]

I am new to Access and trying to create a comparison graph using two queries:

Query 1: [Yr], [Mth], [Count_New_Issues], [Total_New_Issues]
Query 2: [Yr], [Mth], [Count_Closed_Issues], [Total_Closed_Issues]

Where [Total_New_Issues] and [Total_Closed_Issues] are running sums.

I am trying to create a bar graph that will compare the two totals fields. How do I create this?

 

[GaryPanic]

I am no experts but i don't think you can within Access - this is one for excel

if it is do-able this would be one i would be interested in