Data labels for zero value only

[Guest]

Is there a way for the data label values to appear on a chart only for
observations where the value is zero?

I have a clustered column chart where some values are zero. In such cases,
no column appears for these observations (i.e. a column of zero height). I'd
like to have a "0" appear right above the x-axis to indicate a zero value for
that particular observation. All other data labels should be blank
(including all the numbers would make the chart appearance too busy).

I realize I could simply add a text box with a zero. However, the chart is
frequently updated, and there may be some months when the value is not zero.
I'd prefer to have Excel automatically determine whether a data label should
appear.

 

[Andy Pope]

Hi,

One way would be to use a custom number format for the data labels of
;;0

Cheers
Andy

 

[Guest]

Wow ... thank you very much.

Problem solved with a very simple solution.

What exactly does the semicolon ( in a number format indicate?

 

[Del Cotter]

Wow ... thank you very much.

Problem solved with a very simple solution.

What exactly does the semicolon ( in a number format indicate?

It's a divider between the usual three situations the format is for

[when positive];[when negative];[when zero]

You wanted it to be blank when positive, blank when negative, and a
plain integer when zero. Check the Excel help file for more useful
custom number formats.