I have two columns of numbers, A and B. A is just the point number (1, 2, 3, etc.) and B is the corresponding reading number. The reading numbers have massive outliers that when put as a scatter plot make the rest of the values unreadable (for example most values are small decimals but the outliers could be as large as 70). Is there a way to remove numbers outside a certain range while still keeping their corresponding point numbers (so the plot would just have a blank space where the outliers were rather than shifting the other data to fill in the gap. The data sets change constantly (one might be 900 points, the next could be 1100) so I essentially need to make a sheet I can paste the data into and have it remove the outliers and plot automatically.
I have tried using the basic filters but they were giving me the problem with filling in the gaps of the outliers like they never existed and were making plotting difficult and results inconsistent from data set to data set
sorry if its tough to understand, if any clarification is needed let me know
Bookmarks