Future data cells should be empty.
If they contain formula then the result for empty data should be NA()
rather than "". Charts treat text values, which "" is, as zero.
NA() will only stop the data marker being plotted. The line will be
interpolated between valid data points. But as your future points will
not contain any valid points the line will stop.