Partial Trendlines

S

Soozie

Ok i have 3 series, 2 of them i am doing trendlines but the lines go all the
way on the chart and I just want them to cover the same space as the data on
the series how can I make that trendline only go with the data?
 
M

MartinW

Hi Soozie,

Maybe the Forecast settings.
Right click on the trendline
Select Format Trendline
Select the Options Tab
Make sure both forward and backwards are
set to zero in the Forecast box.

HTH
Martin
 
Top