Hi,

If the cell is truly empty and the line drops to zero select the chart
and
check,
Tools Options Chart Plot empty cells as...

If the cell actually contain conditional formula use NA() instead of
"" for
non data. This will interpolate the line but suppress the line marker.

Please check the link for more information.
http://www.andypope.info/charts.htm

Cheers
Heera