How-to not plot cells with zero value on graphs

H

hopeace

Hey! ANyone know how to not plot values if they equal zero in the
graphs?

Thanks!!

keith
 
B

bob777

I had this problem. I wrote a macro that scanned my data and wherever it
found a value of zero it deleted the cell contents. They then do not
plot on charts. My data values were complex formulas, so I wrote a
second macro to reinstate the formulas so that the cells were able to
display correct values when the base data changed.
 
A

Andy Pope

Hi,

Depending on the chart type you could have used a formula instead of VBA.

=IF(test=0,NA(),test)

where test is you complex formula.

Cheers
Andy
 
Top