NA() works for line and XY charts. Try "" for column or bar charts.

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


"@bhi" wrote in message
...
I have the same problem. I tried using NA() but it displayts #NA as a
column
in chart. Any suggestion ?