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


--
Rajkumar

Eager to learn more about Excel
------------------------------------------------------------------------
Rajkumar's Profile: http://www.excelforum.com/member.php...fo&userid=2159
View this thread: http://www.excelforum.com/showthread...hreadid=493770