Query for a Chart?

[treva26]

I have a table called Projects
Each project has a Target Close Date
And some have an Actual Close Date

I want to create a chart that has months on the vertical axis (July to June)
and number of projects on the Horizontal axis

Then I want 2 lines on the chart showing how many projects were supposed to be completed and how many actually completed by each month. ie a running total

I think I need to make a query to get the data for this chart, but i dont know how...

 

[treva26]

Still going nowhere fast...

I did manage to make 2 queries to give the the total number per month, but not every month is listed and I cant seem to combine them.