Graph where source data has different dates

  • Thread starter Thread starter Chas
  • Start date Start date
C

Chas

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!
 
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.
Click to expand...

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.
 
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.
Click to expand...

Slip of the fingers. I meant independent x-*ranges* for one x-axis.
 
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
 
Back
Top