When you add data labels to your chart, zeros will show up by default. This can look quite ugly in some cases, particularly on pie charts.
There are a couple of solutions to remove the zeros.
Option 1 Replace the zeros from the source data with blanks
If your source data is currently the formula =A1+B1 you might remove zeros with an IF statement:
Now the source data is blank, the chart labels will be too e.g. on the below Gasquet and Tsonga have been replaced with blanks but Berdych, Ferrer and Nishikori haven’t.
Option 2 Using custom number formats
Maybe your source data isn’t a formula, so it’s more convenient to remove zeros by using a custom number format.
In this example you want to remove the zero data label for the French Open.
Do you know any alternative methods of removing zeros from the data labels in charts? If so, please leave a comment below.