Andy Pope has a solution on his site . . .

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

----
Regards,
John Mansfield
http://www.pdbook.com

"Kalabbi" wrote:

I have a workbook that contains a lot of pie charts that pull data from the
various worksheets. Sometimes the value is "0" for a data point and I would
like to know if there is a way to hide the data labels for these data points
so I don't have to manually hide them. The data in this workbook is changed
often so I don't want to delete the data labels and then have to go through
the process of re-inserting them later.