Query for Chart

[treva26]

I want to make a chart that shows the number of PLANNED CLOSE DATES and the number of ACTUAL CLOSE DATES for each month of the current financial year.
How do I make the Query to base this chart on?

Its been driving me crazy!

 

[MStCyr]

Hello

I encountered a problem with the database...there's a table or query missing

 

[Dumbfounded]

Graph Problem

Hi,

From what I can see you need to add your area id to your query otherwise there is no data for it to calculate, then make a new chart report and have the area id as your data section (which will be a count of) and then your other two items will be included in the graph.

You can then decide which kind of graph you need to display your output.

Hope it helps.

Thanks,

Donna