Forum Discussion
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.
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.
I missed the "not" in the initial questions so I guess your's is the correct one