Take out the internal "=":

=IF(test<0,test,NA())

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



"Andy Pope" wrote in message
...
Hi,

Use Bernard's suggestion of NA() in your formula. Something like,

=IF(test<0,test , =NA() )

Cheers
Andy

Rajkumar wrote:
Thanks Bernard,

But my Source Data is depended on some formulaes,hence when the result
of them returns zero,the same gets displayed in the chart also.

Is there any other way.

I am sure you can help me.

Regards,
Rajkumar



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info