Trendlines

[Lorne]

A co-worker wants to use the Trendline function on a series of data that contains some anomalous numbers that she would like to exclude. However, she still wants to display these numbers on the chart. I would be interested in what others recommend as being the best way of handling this. Best we can figure is to replicate the data excluding those points and do the trendline on that.

[PaulJ]

Lorne,
Plot the data as two series, adding a trendline only to the series that is required.

PaulJ

[Lorne]

Thanks for your help, Paul.