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