I have a chart getting data from a spreadsheet, where data is added one day
at a time, for an entire month.

After adding the data for the first day, the data point shows, but the line
connecting the data point in the chart immediately drops to zero, since data
for the remaining days is not available.

Is there a way to just have the line connecting the data points show only
where there is data, and not show anything for the upcoming days where data
is not available?

Thanks.