Two Queries > One Query > Graph

[dvent]

Hi All,

I have 2 queries that work out similar pieces of info. The results from the two are shown below:

QUERY1

http://img689.imageshack.us/img689/3626/95882059.jpg

QUERY 2

I want to combine Query 1 and Query 2 to list dates in column A, Forecast GLs in Column B and Expr2 in Column C.

I want to then use the table produced to create a bar chart showing the values each month i.e. 2 bars per month.

Can anyone assist with merging the queries please?

Thanks
dvent

 

[DCrake]

Create a third query that includes 1 and 2 and do a join on the dates. Then drag down Go Live and FL from query one and Expr2 from query 2

 

[dvent]

Thanks DCrake. Done it!