An alternative is to arrange your data so that you have months in rows and
years in columns:
2007 2008
Jan data data
Feb data data
Mar data data
Apr data data
etc.
You can do this manually or using a pivot table. If using a pivot table, use
date as a row field, group date by month and year, then drag the year field
to the columns area. I show how to accomplish this in more detail in my
blog:
http://peltiertech.com/WordPress/200...a-pivot-table/
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Jerry" wrote in message
...
Is there a way to make a chart that compares the two same months of
different years worth of data?
For example, my spreadsheet has the date starting with January 2007 -
June 2008 as the header listed in order. I have some charts built off
of that but would like a bar chart that also lets me compare Jan 07
next to Jan 08, Feb 07 next to Feb 08, and so on.
Any ideas?
--
Jerry