Data labels for zero value only

T

Tyler H

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.
 
A

Andy Pope

Hi,

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

Cheers
Andy
 
T

Tyler H

Wow ... thank you very much.

Problem solved with a very simple solution.

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top