Data labels for zero value only

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.

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tyler H" wrote in message
...
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.

Wow ... thank you very much.

Problem solved with a very simple solution.

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



"Andy Pope" wrote:

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tyler H" wrote in message
...
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.

On Wed, 18 Jul 2007, in microsoft.public.excel.charting,
Tyler H said:

"Andy Pope" wrote:
One way would be to use a custom number format for the data labels of
;;0

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.