There in lies the problem. There is nothing that can be returned to say "ISEMPTY". It's a feature we have asked MS to provide.

If your data is not too complicated you can try
http://www.andypope.info/charts/brokenlines.htm

Otherwise VBA to clear the cells is the only other option.

Or I guess you could use multiple series to plot the segments.