na() and #na label displayed on graphs...
 

Hi all,

I have got a list of data and some are resulting from the NA()
function.
Objective is to avoid a 0 value plot on the graph..... and it is
working great.
BUT
On the graph, I set the label of each ploy to "value". And
unfortunately a #NA label is displayed on the graph on each plot where
there is the NA()...

How can I remove the #NA from my graph ?

Thks,

AL.

na() and #na label displayed on graphs...
 

In a column or bar chart, you may as well use "". NA() is what works only
for marker series (line, XY, and some radar series) by completely hiding the
point. In column and bars, the point is plotted, but has a value (and thus
size) of zero; since the point is plotted, it can have a value in the data
label.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
ups.com...
Hi all,

I have got a list of data and some are resulting from the NA()
function.
Objective is to avoid a 0 value plot on the graph..... and it is
working great.
BUT
On the graph, I set the label of each ploy to "value". And
unfortunately a #NA label is displayed on the graph on each plot where
there is the NA()...

How can I remove the #NA from my graph ?

Thks,

AL.