View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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