I have created a report that includes a chart which displays the attendance data for a meeting. The data is broken up into the weeks of a month. I then compare the attendance of the previous years data to the current year. My problem is that currently the chart shows the data as it is in the database, first the weeks for the previous year and then the current year. What I would like to see is the 2 weeks of both years together and so on eg:

01/01/2007 200
08/01/2007 100
15/01/2007 250
22/01/2007 300

01/01/2008 100
08/01/2008 230
15/01/2008 280
22/01/2008 500

The above data is charted on a line graph in 1 colour.

What I want to see is the following:

01/01/2007 200
01/01/2008 100
08/01/2007 100
08/01/2008 230
15/01/2007 250
15/01/2008 280
22/01/2007 300
22/01/2008 500

I would also like to see each year in a separate colour.

Any help would be appreciated.