View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] a.lagolep@caramail.com is offline
external usenet poster
 
Posts: 4
Default 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.