Charting Same Month from different years?

[Kimagine]

I keep a log of laser printing volume by month. I now have over four years' worth of data and have started doing reports on yearly totals.

What I want to do now is have some charts that show volume for a particular month over those years, for example:

Chart 1: Jan 99 Jan 00 Jan 01 Jan 02
Chart 2: Feb 99 Feb 00 Feb 01 Feb 02
etc.

Haven't been able to figure out how to accomplish this! Can anyone help?

Thanks!

 

[BobSuruncle]

Try This:
1.)Create a formula to Group your report by Month
@Month#
ToText(Month({Orders.Order Date}),"00&quot

2.) Customize the Group Name to use a Formula for the Name
ToText({Orders.Order Date},"MMM&quot

3.) Create a Formula for the Year
@Year
ToText({Orders.Order Date},"MMM&quot+ "-" + ToText({Orders.Order Date},"yy&quot

4.) Insert a Chart.
- On the Data tab, choose to Place the Chart once for each @Month#
- For the OnChangeOf, choose the @Year formula
- For the Show value, choose the value that you want to graph

HTH


Bob Suruncle