If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
Graph where source data has different dates
On Wed, 1 Oct 2008, in microsoft.public.excel.charting,
Chas said: I'm trying to do a comparison 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. To help, can you post a piece of your table so we can see how you've arranged it? All your dates must be in the same column for a Line Chart with Time-scale x-axis. It's only possible to have independent x-axes with an XY (Scatter) Chart. -- 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
|
|||
|
|||
Graph where source data has different dates
On Thu, 2 Oct 2008, in microsoft.public.excel.charting,
Del Cotter said: Chas said: I'm trying to do a comparison 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. All your dates must be in the same column for a Line Chart with Time-scale x-axis. It's only possible to have independent x-axes with an XY (Scatter) Chart. Slip of the fingers. I meant independent x-*ranges* for one x-axis. -- 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. |
#4
|
|||
|
|||
Graph where source data has different dates
Thanks Del,
I actually found a very similar post & was able to work it out. I had to change the chart type to a XY Scatter. Thanks "Del Cotter" wrote: On Thu, 2 Oct 2008, in microsoft.public.excel.charting, Del Cotter said: Chas said: I'm trying to do a comparison 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. All your dates must be in the same column for a Line Chart with Time-scale x-axis. It's only possible to have independent x-axes with an XY (Scatter) Chart. Slip of the fingers. I meant independent x-*ranges* for one x-axis. -- 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. |
Thread Tools | |
Display Modes | |
|
|