Jon,

I don't think I follow. The idea is to make the label disappear when the
value is zero. The label and the value are in separate cells.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jon Peltier" wrote in message
...
Alternatively, you can use a custom number format that excludes zero
displays, like one of these:

0;;;
0%;;;

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Earl Kiosterud wrote:

To add to Peter's response, you can make a separate column for the pie
labels (presuming you're using labels, not the legend, for the slices)
that yields an empty string for those values that are zero. This way,
you get no labels for zero-value items:

Label Chart label Value
Tom =IF(C2<0, A2, "") 1
Sally =IF(C3<0, A3, "") 0
etc.

Use the Chart Label column for the chart. You can hide that column.