View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
tirrill tirrill is offline
external usenet poster
 
Posts: 2
Default 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?