data labels on charts

[Genevieve]

Is there any way to make it so that zeros do not appear on charts when you
display data labels? I know you can go in and delete them, but I was hoping
to set up a template that would automatically leave out all zeros.

Thanks!

 

[Andy Pope]

Hi,

You can use a custom number format for the data labels,
General;-General;

Cheers
Andy

 

[Genevieve]

Awesome! That worked. Thanks

Hi,

You can use a custom number format for the data labels,
General;-General;

Cheers
Andy