On Tue, 27 Mar 2007, in microsoft.public.excel.charting,
tmirelle said:
I am working with a stacked column chart, & when I use the NA() It
actually adds #NA to the graph. Am I SOL? or is there a way to get
rid of the NA (or 0) values

"Del Cotter" wrote:
It does? So it does; that's annoying. Maybe there's something you can do
with custom number formats, although a couple of minutes trying didn't
produce anything for me.

Found the solution in case it is helpful to others...

set data label format to:

General;;;

[*slaps forehead*] Of course!

Thanks for coming back with that.

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