offsetting periods in chart

Win XP HE, XL 2002
Hi, I have a chart with 4 data series.
Each of these series start in offsetting dates--each a week later, for
example.
At the moment, I only have 1 x axis with dates.
This causes the later data series to start too early and end too
early--where the actual dates are not matched--there is only one x axis.
How can I have each series start on the proper dates--each a bit later (a
week) than the one before it--they all end on the same date.
Tx!
S

Try setting your data up similar to this:

Ser 1 Ser 2 Ser 3 Ser 4
01/02/2005 5
01/09/2005 5 6
01/16/2005 5 6 7
01/23/2005 5 6 7 8
01/30/2005 5 6 7 8

You can also add the formula "=NA()" to cells where you don't want data to
appear.

Another option - go to the standard toolbat and click on Tools -> Options ->
Chart Tab and make sure that you have the "Plot empty cells as not plotted"
option checked.

----
Regards,
John Mansfield
http://www.pdbook.com


"saturnin02" wrote:

> Win XP HE, XL 2002
> Hi, I have a chart with 4 data series.
> Each of these series start in offsetting dates--each a week later, for
> example.
> At the moment, I only have 1 x axis with dates.
> This causes the later data series to start too early and end too
> early--where the actual dates are not matched--there is only one x axis.
> How can I have each series start on the proper dates--each a bit later (a
> week) than the one before it--they all end on the same date.
> Tx!
> S
>
>
>

Jphn,
I can do Tools > Options
> Chart tab and "Plot empty cells as not plotted" option checked; in one
chart but same option is grayed out in other chart....


John Mansfield wrote:
> Try setting your data up similar to this:
>
> Ser 1 Ser 2 Ser 3 Ser 4
> 01/02/2005 5
> 01/09/2005 5 6
> 01/16/2005 5 6 7
> 01/23/2005 5 6 7 8
> 01/30/2005 5 6 7 8
>
> You can also add the formula "=NA()" to cells where you don't want data to
> appear.
>
> Another option - go to the standard toolbat and click on Tools -> Options
> -> Chart Tab and make sure that you have the "Plot empty cells as not
> plotted" option checked.
>
> ----
> Regards,
> John Mansfield
> http://www.pdbook.com
>
>
> "saturnin02" wrote:
>
>> Win XP HE, XL 2002
>> Hi, I have a chart with 4 data series.
>> Each of these series start in offsetting dates--each a week later, for
>> example.
>> At the moment, I only have 1 x axis with dates.
>> This causes the later data series to start too early and end too
>> early--where the actual dates are not matched--there is only one x axis.
>> How can I have each series start on the proper dates--each a bit later (a
>> week) than the one before it--they all end on the same date.
>> Tx!
>> S