how do you get a trendline to ignore anomalies?

R

Rico

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?
 
J

Jerry W. Lewis

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

Jerry
 
B

Bill Martin

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

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)
 
Top