How not to plot zero & error values in Excel plot

Hi,   I'm looking for a way to avoid plotting errors and zero values in Scatter Plot. I have a big chunk of values (populated using equations), 1000 rows, and 4 columns. Some of the cells (random) ...