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.
8 Replies
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.
Riny_van_Eekelen I want to thank you also because it save me a lot of grief
- I missed the "not" in the initial questions so I guess your's is the correct one
PascalKTeam I would like to prevent the zero from showing, if the zero turn to 5 or 10 then it should show 5 or 10
