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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

a.lagolep@caramail.com - 26 Oct 2006 21:37 GMT

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.

Reply to this Message

Jon Peltier - 27 Oct 2006 03:15 GMT

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
_______

> Hi all,
>
[quoted text clipped - 12 lines]
>
> AL.

Reply to this Message