Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Annualize/ Estimate year-to-date from monthly expense | Excel Worksheet Functions | |||
linking 12 monthly workbooks to one year to date workbook | Excel Worksheet Functions | |||
How do i repeat dates monthly over the year | Excel Worksheet Functions | |||
monthly ppmt calculated in 1 cell for year | Excel Discussion (Misc queries) | |||
Showing data per month & year for comparison | Excel Discussion (Misc queries) |