The advice about using NA() in a formula to hide a data point works fine for
line or XY charts. The best advice for a column or bar chart is to use ""
instead.

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


"Bernard Liengme" wrote in message
...
Interesting. I made a Line chart with =NA() and the points were joined (as
expected)
When I added labels, the #N/A did NOT appear
A copy of the same charge was changed to a Column chart and the #N/A does
appears
But then, with a column chart you could just leave the cell blank.
What type of chart are you using?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Bob Arnett" wrote in message
...
I am using Excel 2007 and have found that I cannot get the NA() labels to
NOT
display. As desired, there is no column where the cell values are na()
but
the labels for those cells are displaying as "N/A". How do I keep these
labels from appearing?