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.