Plot scatter plot without including blank cells or cell with #n/a or #value

Hi,

I want to plot several scatter plots without including blank cells or cell with #n/a or #value. Assume A2:A8000 AND B2:B8000 are the cells containing the two variables to be plotted.

Any help is highly welcome. Kindly find attached the spreadsheet showing the data requiring scatter plots for each pair.

Cheers.

Charts already ignore errors and empty cells.

In the particular case of cells that have an empty text string -- "" -- then maybe wrap a helper function that throws an error code, and chart of off that (in C2:C8000 say)?

None of the cells appear to be blank or empty (meaning that ISBLANK(cell reference) returns TRUE). The ISTEXT() function suggests that all of the cells that look blank contain some kind of invisible text string -- and scatter plots treat text (even empty text "") as the number 0. The usual strategy for ignoring cells that contain a formula is to have the formula return the N/A error [NA() function]. Full discussion here: https://peltiertech.com/mind-the-gap...g-empty-cells/ The solution I see, as ben_hensel suggests, is to use a formula to replace those invisible text strings with N/A.