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

On Wed, 9 Jul 2008, in microsoft.public.excel.charting,
Jerry <jerryalan@gmail.com> 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_...cycle_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 del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

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/20...-a-pivot-table/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jerry" <jerryalan@gmail.com> wrote in message
news:35d06fe2-9bb2-4b33-8167-37b01ffba854@2g2000hsn.googlegroups.com...
> 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