Chart with dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Back
Top