Chart with dates

V

Vantastic

Hi everyone

I'm relatively new to drawing charts. I can do the basics easily enough.

What I have is a table which has all the earnings on a day by day basis over
the course of 2 years. I can output this info into a graph, shown monthly,
quarterly or however I decide.

What I would like to do is have one year overlaying the other, grouped by
months, so that a comparison can be made easily.

For instance, one line representing 2005, the other 2006. Is this possible?

Thanks
 
D

Duane Hookom

I think you can use a crosstab query that has month as the Row Heading, year
as the Column Heading, and Sum of Earnings as the Value.
 
V

Vantastic

Thanks Duane, will try it out but that makes sense.... I've never used a
cross-tab query before but this is a simple query so I doubt there'll be any
probs.

Cheers
 
Top