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