I am not 100% positive this is your situation, but I believe I ran into the
same problem a few weeks back. On your spreadsheet got to Tools/Options,
then on the View tab uncheck Zero values.

"ML" wrote:

I am trying to create a chart from data that is in the form of a formula,
some of those cells have a formula that returns a blank cell, "". I want my
line chart to stop if the cell is blank, instead it is showing as a zero
value.
Any ideas on how to do this.