Partial Trendlines

[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?

 

[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

 

[Soozie]

Nope tried that both are set at "0".

thanks though for the tip!