fit a trend line w/o outliers

[David Wang]

Hi,

I made a simple scatter plot in Excel and found an outlier. I want to
keep the outlier anyway on the chart while fitting a trend line with
all the data points except the outlier. How should I do it?

Thanks,
David

 

[Bernie Deitrick]

David,

Copy the column of data to another column (or use formulas), delete the outlier point, then fit the
trend line based on the new set of points, but graph the old set.

HTH,
Bernie
MS Excel MVP