View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Soozie Soozie is offline
external usenet poster
 
Posts: 2
Default Partial Trendlines

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?