Have your formula return NA() and the "zero" value won't be displayed.

"metro" wrote in message
...
In the worksheets, I can easliy turn off display of zero values. In the
charts, I cannot find i similar option.
When formulas return a 0, N/A or empty cell (""), the chart seems to
handle
it as a 0. I do not want to display those data points at all. How do I do
it?