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!

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Genevieve" <(E-Mail Removed)> wrote in message
news:7CF15AB0-390F-49CF-B7B9-(E-Mail Removed)...
> 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!

Awesome! That worked. Thanks

"Andy Pope" wrote:

> Hi,
>
> You can use a custom number format for the data labels,
> General;-General;
>
> Cheers
> Andy
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "Genevieve" <(E-Mail Removed)> wrote in message
> news:7CF15AB0-390F-49CF-B7B9-(E-Mail Removed)...
> > 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!
>
>