Thread: How do I hide data labels in a pie chart that have a value of 0?

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.

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.

If all your labels contain is the value, you can use a custom number
format. Double click the labels, click on the Number tab, select Custom
in the left hand list, and enter soemthing like this

0;;;

in the box. A custom number format has up to four items, arranged like this:

{positive format};{negative format};{zero format};{text format}

The format above tells Excel to use "0" as the format for positive
numbers, nothing for negatives, nothing for zeros, and nothing for text.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.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.