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.