Excluding and Formatting Outliers in Excel Charts

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.

[@tejas.a06]

You flipping legend

[@MiniMeags]

THANK YOU

[@lena777bogdan]

Thank you for shearing your knowledge with others. It's a very helpful video.

[@Yoonsoo-tx8my]

This is very helpful, thank you so much.

[@yourlonglosttwin5287]

Thank you so much!! Really helpful and simple to understand!! just used this in some university coursework!

[@adinanibnmubarak1410]

Thank you very much, You make it look simple

[@tgregg75]

Simple and helpful. Thank you!!