How can I hide 0-value data labels in an Excel Chart?
- Right click on a label and select Format Data Labels.
- Go to Number and select Custom.
- Enter
#""
as the custom number format. - Repeat for the other series labels.
- Zeros will now format as blank.
NOTE This answer is based on Excel 2010, but should work in all versions
If your data has number formats which are more detailed, like #,##0.00 to show two digits and a thousands separator, you can hide zero labels with number format like this:
#,##0.00;(#,##0.00);
The first part (before the first semicolon) is for positive numbers, the second is for negative numbers (this particular format will put parentheses around negatives), and the third, which is missing, is for zeros.