Not Able to Leave Gaps on Line Chart

Hi,

I rewrote this question to be a bit more clear.

On line charts, I know you can choose to prevent interpolation by using the Tools->Options->Chart tab option--which works when cells are empty. But I have cells with formulas that return #N/A. These cells don't plot--which is great--but I don't want the plotted line to interpolate the plots of data that come before and after the #N/A cells. I want gaps. Is there a way I can do this?

Thanks in advance,
Christiaan V