Hiding Zeros in Stacked Bar Charts

Hi

How do I hide Zero values in a stacked Bar Chart?

I want to display amounts in the bars but not when they have zero values.
Could you please help me.

Regards
Darshan

Hi,

I assume you are referring to the data labels, in which case use a
custom number format to suppress zero.

General;General;

Double click the data labels and use the Number tab to add this number
format.

Cheers
Andy

Darshan72 wrote:
> Hi
>
> How do I hide Zero values in a stacked Bar Chart?
>
> I want to display amounts in the bars but not when they have zero values.
> Could you please help me.
>
> Regards
> Darshan
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info