View Single Post
  #6   Report Post  
Jon Peltier
 
Posts: n/a
Default

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.