title: Excel graph hide data label if = #N/A
body: <p>In Excel, I am generating a bar chart from cells using the N/A() function (=IF(value=0,NA(),value)).
  <strong>I precise I cannot use "" instead of n/a() and I must use bar graphs.</strong></p>
  
  <p>My problem is I cannot prevent data labels from showing #N/A for N/A cells...</p>
  
  <p>I tried many formats for the data label, using this definition:
  <strong>positive;negative;zero;text</strong>.
  For example this one:  <strong>0;-0;;</strong></p>
  
  <p>It prevents well any text, or 0 value to be displayed in data labels... But #N/A remains.</p>
  
  <p><a href="https://i.stack.imgur.com/hiGrn.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hiGrn.jpg" alt="enter image description here"></a></p>
  
  <p>I have read many topics on various forums and sites without success.
  Could you please help on this ?</p>