Automatically updated chart show empty cells as a gap - how to fix it?

[hmgrts]

Formulas in C-column causing chart show empty cells as a gap. How to fix it?

The attached file has a properly displayed chart.

Thanks,
hmgrts

[Chance2]

If you change your COUNTA to COUNT it will only see numbers (not formula's).
Also, your yVal needs to move up one...

xVal=OFFSET(Sheet1!$A$2,0,0,COUNT(Sheet1!$A:$A),1)
yVal=OFFSET(Sheet1!$C$2,0,0,COUNT(Sheet1!$B:$B),1)

[hmgrts]

Thank you very much!