View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default x-axis time series with 2 different begin dates

I don't understand why you say that a line graph would show things that the
XY graph won't?
Maybe so if you only look at the version of XY with points and no lines, but
the XY graph can include the lines (and leave out the points if you want to
do so), and has the advantage that it does treat the X values as data
values, rather than category labels.
--
David Biddulph

"tirrill" wrote in message
...
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?