Monthly Comparison By Year
 

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

Monthly Comparison By Year
 

On Wed, 9 Jul 2008, in microsoft.public.excel.charting,
Jerry said:

Is there a way to make a chart that compares the two same months of
different years worth of data?

Try this page

http://processtrends.com/pg_charts_m...ycle_chart.htm

Or Google "excel cycle-plot"

http://www.google.com/search?q=excel+cycle%3Dplot

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Monthly Comparison By Year
 

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