Selective Trendlines

C

Chad

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

remove "linear" from trendline legend entry 2
Creating a Chart on form from selected data in query. 0
Trendline partial data 2
Trendline in Stacked Column Chart 2
Help with area under trendline 0
Creating a linear trend line in Excel 0
Sine trendline in scatter? 5
Trendlines: When They Will Be Generated, And When They Will Not BeFor A Scatter Chart 0

Top