Jakob -

Use conditional formatting to hide it:

http://contextures.com/xlCondFormat03.html#Errors

Or break down and create two ranges, one for display of the data, the other for the
chart's source data. If you link them to the original data, they should agree.

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

Jakob Austgulen wrote:

But I dont want #NA in my sheet.