equation inside the chart variables

[SergeyZh]

Hi Excel Guru
I made a scatter chart in excel and some of the numbers in Y axis have a negative value inside the squire root. These numbers are shown as #NUM! values in the cells.
The X and Y values of the chart have the range from 1 row to 4307 row. Changing the input values to redraw the chart some numbers become #NUM! because of the negative value inside the square root.

Is it possible to add a formula into the Series X and Y values to exclude those cells with #NUM! values in the range from 1 to 4307 cells?

 

[6StringJazzer]

Change the formula in J to be

=IFERROR(SQRT(F1),NA())

and fill down