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