How-to not plot cells with zero value on graphs

[hopeace]

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

Thanks!!

keith

[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.

[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

bob777 wrote:
> 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.
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info