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.


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=487862