Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Comparing data from 2 monthly periods in 1 chart
I am trying to compare 7 coloumns of data (Housing Advice Stats) from May to
Oct 06 to the same set of data taken in May to Oct 07. Ideally I'd like to lay one over the top of the other so I can see the differences from one year to the next ie, have 2006 as a column chart and 2007 as a line chart. Any ideas how I do this? So far the only charts I have created have been a mess! Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Comparing data from 2 monthly periods in 1 chart
Assuming you have true dates as the X data, you could put the data into
different tables by year, and normalize the dates by subtracting December 31 of the prior year from all dates. Or you could keep the data in a single table, create a pivot table with date in the rows area and the value in the data area. Then group the dates field by year and by day. Then drag the Years field button to the columns area. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jamie" wrote in message ... I am trying to compare 7 coloumns of data (Housing Advice Stats) from May to Oct 06 to the same set of data taken in May to Oct 07. Ideally I'd like to lay one over the top of the other so I can see the differences from one year to the next ie, have 2006 as a column chart and 2007 as a line chart. Any ideas how I do this? So far the only charts I have created have been a mess! Thanks. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Comparing data from 2 monthly periods in 1 chart
Jamie:
It sounds like you need a day of year chart to compare your data. Take a look at this post to see what a day of year chart looks like: http://processtrends.com/pg_charts_D...comparison.htm If the chart on the right looks like what you want, I'll be glad to set it up for you. Just e-mail me your file koday*at*processtrends*dot*com (be sure to clean up my anti spam address) Kelly http://processtrends.com "Jon Peltier" wrote in message ... Assuming you have true dates as the X data, you could put the data into different tables by year, and normalize the dates by subtracting December 31 of the prior year from all dates. Or you could keep the data in a single table, create a pivot table with date in the rows area and the value in the data area. Then group the dates field by year and by day. Then drag the Years field button to the columns area. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jamie" wrote in message ... I am trying to compare 7 coloumns of data (Housing Advice Stats) from May to Oct 06 to the same set of data taken in May to Oct 07. Ideally I'd like to lay one over the top of the other so I can see the differences from one year to the next ie, have 2006 as a column chart and 2007 as a line chart. Any ideas how I do this? So far the only charts I have created have been a mess! Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vertical line on column chart with monthly data | Charts and Charting in Excel | |||
How to subtract/add periods in monthly base? | Excel Discussion (Misc queries) | |||
Comparing 2 years of data on a monthly basis | Charts and Charting in Excel | |||
Number of semi-monthly periods between 2 dates | Excel Worksheet Functions | |||
Mortgage template comparing interest pd, monthly, bi-monthly, ext. | Excel Discussion (Misc queries) |