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