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

  • Thread starter Thread starter a.lagolep
  • Start date Start date
A

a.lagolep

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top