Excluding and Formatting Outliers in Excel Charts
Channel: Chris Armstrong
Date: 2021-01-11

This video demonstrates one approach to showing outliers on calibration graphs without hiding them. This is specifically for how we quickly do a particular thing in a physical chemistry teaching lab. It is not a rigorous statistical approach.

Note: if you drag outliers into a different column, LINEST() breaks. If you want it to work, then FILTER() in the more recent versions will do it. If you have x values column A and y values in column B, with outliers shunted into column C, then =FILTER(A1:B10,ISNUMBER(B1:N10)) somewhere will return a list of non-blanks.

Without FILTER(), it's a more complicated formula you need to create involving errors, returning small values, and then dragging down... I would recommend just looking up "return non blank values excel" via your favourite search engine of choice.