I just did this in 2007, but the concept should be the same.
Setup test data.
1. Setup a date column with Jan 09 - Dec 10
2. I then setup random data in the column next to it
I then selected both the date and data column for 09 and created a chart.
So far so good.
Next I setup a new column with the Months only eg: JAN, FEB... DEC
Using the "Select Data Source, I changed th "Axis Labels" to the Month only column.
Then I added a new series and only select the data column for the next year.
I changed the series name to 2009, and 2010 to match the years.
The chart looks correct.
I used a line chart.
Bookmarks