Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph where source data has different dates
I'm trying to do a comparision line graph with two series of data. The are
both tracked by date with the same range (from April 2008 to April 2009). However one series has data monthly and the other has data weekly. When I try to combine on a graph the dates just don't line up. Is it possible to have these line up correctly. I've tried formatting the axis to days instead of months but it appears to only line up data points. So for the data reported monthly, it is graphed across the first 12 days. Hopefully that makes sense. If not, just let me know & I'll try to clarify. Thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Graph where source data has different dates
Make the line chart with the first set of data, and set the X axis to use
days as the base unit. Add the second set of data, which produces a second line series using the X values for the first series. Convert just this series to an XY type, which breaks its dependence on the first set of X values. Then, in Excel 2003 or earlier, you can move the XY series back to the primary axis, and it will be aligned appropriately. In 2007 you have to keep the XY on the secondary axis, and align all the scales yourself. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Chas" wrote in message ... I'm trying to do a comparision line graph with two series of data. The are both tracked by date with the same range (from April 2008 to April 2009). However one series has data monthly and the other has data weekly. When I try to combine on a graph the dates just don't line up. Is it possible to have these line up correctly. I've tried formatting the axis to days instead of months but it appears to only line up data points. So for the data reported monthly, it is graphed across the first 12 days. Hopefully that makes sense. If not, just let me know & I'll try to clarify. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Source Data in a Graph | Excel Discussion (Misc queries) | |||
showing source data from a graph | Excel Discussion (Misc queries) | |||
Data Source for excel graph | Excel Discussion (Misc queries) | |||
Graphs/Charts by country. Same Graph, different Source Data | Charts and Charting in Excel | |||
Excel graph source data | Charts and Charting in Excel |