This is very strange. I KNOW I have done plots  that simply omit non exsistent
data, but
couldn't figure out how i Used to do it [brain tells me there 'was' a
"Plot-Zero-Values"
option, but brain has been wrong B4].

I tried an X-Y plot  - nope.

This may get you closer to a solution...
Here's what is the strangest.
I found that If I Paste Values (from the formula  cells), the chart  STILL
plots "empty" cells
as zero.
HOWEVER, if I Clear Contents in that cell, then the point and connecting
lines are
omitted!

So...
A "" is interpreted as a zero.
A Pasted Value of "" is interpreted as a zero.
a Cleared cell  is undefined / unplottable.


So, do a TypeName on the three types of "blank" cells( "" in formula, a Pasted
"" from a
formula and a fully Cleared cell) to see what they are.

This may mean you'll need a macro  to Clear a copy of the Zero valued cells.

Wa-Da-Ya-Think?