How do I chart something with some missing data?

[Rod]

I've been tracking the status of our grant money in one of our databases. I
try to track this each day, but sometimes I miss tracking it one or two days
at a time. Anyway, I would like to chart the draw down rate of this fund,
but as you can see I don't always have a value for each day. How do I do
this for days that I'm missing?

 

[Bernard Liengme]

In the empty cell type =NA()
This displays as #N/A
The chart engine will ignore these values
best wishes