How do I chart something with some missing data?

  • Thread starter Thread starter Rod
  • Start date Start date
R

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?
 
In the empty cell type =NA()
This displays as #N/A
The chart engine will ignore these values
best wishes
 
Back
Top