View Single Post
  #1   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

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?