Chart "Connect data points with line" for "Hidden and empty cells"

Hi!

With a line chart I'm having the following problem. I have data produced by formulas, which can produce either a value or empty. I want to make a line chart where data points are the non-empty values and the empty cells are connected by a line.

But using the "Hidden and empty cells" option of chart, it considers the empty cells as zeros, not blanks, if the "emptiness" is returned by a formula. Is this a bug in Excel or a problem in my usage?

Attached is a screenshot with comments, which might clarify the issue, and also the sample excel from which the screenshot was taken.

Thanks in advance!
Suni.