Can anyone help please?

I have a column in my woksheet that contains formulae that refers to blank
cells. Therefore the result is zero in each cell in my column. When I use
the data in a chart, I set Tools, Options, Chart tab - plot empty cells as
"Not plotted", but it still plots the cells as zero and distorts my chart.

Is there any way to get is to plot the cells that have a formula where the
result is zero, as "not plotted"?

Any help would be appreciated.

--
Thanks,
Rob E.