offsetting periods in chart

S

saturnin02

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
 
J

John Mansfield

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.
 
S

saturnin02

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