Forum Discussion
wjallen14
Feb 29, 2020Brass Contributor
labels on chart
I remember there use to be a way not to have a label printed if the value of the cell was Zero. Is there still such away.
Riny_van_Eekelen
Mar 04, 2020Platinum Contributor
wjallen14 Since you say "not the have the label printed if zero" you can apply a custom format to the data label. It could be like #,##0;-#,##0;"" This tells Excel to display a -zero- as a blank.
I'm on a Mac so your screen will look differently if you are on a PC.
wjallen14
Mar 07, 2020Brass Contributor
Riny_van_Eekelen I want to thank you also because it save me a lot of grief