Hide 0-value data labels in an Excel Chart


1) Right click on a label and select Format Data Labels.
2) Go to Number and select Custom.
3) Enter #”” as the custom number format.
4) Repeat for the other series labels.
5) Zeros will now format as blank