RSUM question

I'm using RSUM to tally up daily ticket sales.

But where there is a blank cell in the data table (because there were no sales that day) it leaves a blank datapoint on the chart as below.  Anyone got a fix for this?

Parents Reply Children
No Data