Assuming you mean you want empty cells not to be treated as zeros:
1) click on chart; use Tools|Options|Chart and specify how you want blanks
to be treated
or
2) replace blanks by =NA()
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rajkumar" wrote in
message ...

Hi,

Is there any way to avoid displaying zero values in a chart.

Raj


--
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