Another 2 ways in the attached:
On Sheet1, an Autofilter has been applied to column J to keep only rows where the value is greater than 14
On Sheet2, the number 14 has been entered in cell L1. This number is used in the formulae in the cells in column K, to show the number in column J if it's greater than the value in cell L1 or #N/A if it's not. It's this column K which is plotted.
|