View Single Post
  #5   Report Post  
Richard
 
Posts: n/a
Default Trendline - split one into two

If I try this is there a way to not display the two sets of data on the
chart? I don't want to have two idential columns for of the first eight
quarters.

"Roland" wrote:

Yes, plot two data sets, with the same data for for the first 8 quarters, and
differing data after that.

"Richard" wrote:

All,

I can't find a way to break a three year/12 qtr trendline apart in Excel
Charts. I'd like to have one trendline for the first two years (8 qtrs) and
one for the last year (4 qtrs). Is this possible?

Thanks,
Richard