Line Chart with different beginning values
 

I have 3 series I am charting on a 2-d line chart. All series run for about
a year and a half but have different start and end dates. How do I get one
series to start on 10/1/05 and show that another series started on 5/1/05?
When I add the series that starts later, my chart adjusts and I lose the
detail of the 5/1 series.

Thanks.

Line Chart with different beginning values
 

You could use an XY chart, which accepts independent X values for each
series. Or you could pad the beginning and end of each series with blanks to
stagger the series in the chart.

1 3
2 4
3 5
4 6 2
5 7 3
6 8 4
7 5
8 6
9 7

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"DuaneS" wrote in message
...
I have 3 series I am charting on a 2-d line chart. All series run for
about
a year and a half but have different start and end dates. How do I get
one
series to start on 10/1/05 and show that another series started on 5/1/05?
When I add the series that starts later, my chart adjusts and I lose the
detail of the 5/1 series.

Thanks.