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.