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. Here's Jon's format hints page:

http://peltiertech.com/Excel/NumberFormats.html

Otherwise you may have to just manually select the one label by single
clicking twice, then deleting.

On Mon, 19 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

"Jon Peltier" wrote:

If the formula returns NA() instead of "", there will be no point plotted in
a line or XY series. You don't get an actual gap; if the series has lines
connecting the points, a line segment connects the points on either side of
the gap. There are workarounds, which involve raw poultry parts and chants
at full moon.

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