Hiding Zeros in Stacked Bar Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top