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?

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

Nope tried that both are set at "0".

thanks though for the tip! :)

"MartinW" wrote:

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