Dohhh - didn't even see the reference to a Pie chart :-(

Cheers Jon

Regards
Ken............

"Jon Peltier" wrote in message
...
The problem with a zero is not that the wedge will show; it won't. The
problem is that a data label will show. Both suggestions so far, using IF
to replace zero with NA() or with "" still leave an unwanted label, which
either shows 0 or #N/A.

Andy Pope shows a dynamic range technique to omit these zeros on his web
site:

http://andypope.info/charts/piezeros.htm

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


Ken Wright wrote:

Have the data you are pulling from be the result of formulas such as
=IF(xyz=0,NA(),xyz)

This means that in place of 0 you will have N/A and that will not be
plotted on the chart (Unless it is one specific type which will still
show it - Can't remember which).

Assume it's a line chart or something similar and you just don't want the
line dropping to the axis for the missing data.