Hide data labels with "0" values

[Roachie]

Some of my source data contains cells with "0" values that I don't want to
show on my chart. How can I get them to now show up? I need to leave those
cells in my source data range as I am working with a spreadsheet that is
updated monthly so as to automatically update the chart.

 

[Bernard Liengme]

How about a custom format like 0.0;-0.0;""
Right click a data label on chart and select Format Data Labels
best wishes

 

[Roachie]

Thanks Bernard! I was able to get it to work by using the custom format of
0.0;-0.0;

This sight is awesome!

 

[Bernard Liengme]

Thanks for the feedback
Bernard

Thanks Bernard! I was able to get it to work by using the custom format
of
0.0;-0.0;

This sight is awesome!