how do you get a trendline to ignore anomalies?

[Guest]

if i want anomalies to appear on a graph, but want the trend line to ignore
them so it doesn't ruin the trend line, how do i do it?

 

[Jerry W. Lewis]

Plot two data series on the graph, and add the trendline to the series
that does not have anomalies.

Jerry

 

[Bill Martin]

Plot two data series on the graph, and add the trendline to the series

that does not have anomalies

Jerry's approach has the added benefit that it will allow you to plot the
"anomalous" data points with a different color/marker style and label them on
the chart key as being excluded from the trend line.

This makes them obvious on the chart and prevents people from thinking you've
cooked the data -- or at least lets them understand how you cooked it.

Bill -- (Remove KILLSPAM from my address to use it)