Selective Trendlines
 

Hi All,

Is it possible to have a trend line only look at a part the data? Example
use only the last 30 entries or so.

Thanks
Chad

Selective Trendlines
 

Hi,

No. The work around is to create another series which contains only
those data points to be trended. The base your trend line on that
series. The additional series can be formatted so that it does not
appear in the chart.

Cheers
Andy

Chad wrote:
Hi All,

Is it possible to have a trend line only look at a part the data? Example
use only the last 30 entries or so.

Thanks
Chad



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Selective Trendlines
 

I will send you a sample workbook showing Andy's idea
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Chad" wrote in message
...
Hi All,

Is it possible to have a trend line only look at a part the data? Example
use only the last 30 entries or so.

Thanks
Chad