Plotting, Exclude Zeros

I have a large spreadsheet, over 1000 rows and about every tenth line I have a piece of data. Every cell has a formula in it, and the ones that do not have data in it should be blank. They contain "".

When I plot my graphs, I get a large number of zeros, even though none of my pieces of data are zero. Is there a way to exclude these, without having to manually select the individual cells or reformat the scales of the graphs?

Yu could change the formulas to return NA() instead of blanks.

Exactly what I was looking for, thanks.