x-axis time series with 2 different begin dates
It has to be line graphs. A scatter plot would not easily show the
relationship between the 2 different time series.
I have finally found an inelegant way of accomplishing having to different
start dates. I had to first reset my Y-intercept to 0. Then, I formatted
each data point along the 0-line, removing the data points and lines. I then
changed the Y-intercept back.
Thank you for your effort.
"David Biddulph" wrote:
What sort of chart? Have you tried XY(Scatter)?
--
David Biddulph
"tirrill" wrote in message
...
I want to show 2 time series in 1 chart with different start dates. Series
1
begins 1996 and run through 2006. Series 2 starts 2000 and also stops on
the
same end-date 2006. Both use the same $ scale on the y-axis. Excel puts
them both as having start-year of 1996 with the 2nd series stopping in 6
years (2002). How do I "offset" the 2nd series by 4 years?
|