Displaying Trend Data which includes zero values

  • Thread starter Thread starter Christine Wilso
  • Start date Start date
C

Christine Wilso

I am creating trend charts which looks at monthly data from the yea
2000. My data table is set up from April 2000 to March 2005. The chart
are set up to read all this data, so that when the monthly data i
updated the charts are automatically updated with all the values t
date.
However I don't want zero's displaying on my chart on the months tha
havn't occurred, although zero may be a value within the data se
itself.
Is this possible?
I know about using NA() but this doesn't work if zero was a value fo
January 2003 for example, I would want zero to show here, but the grap
to stop at the month to date rather than displaying a line of zero'
from August to March 2005
 
Why do you think NA() is not appropriate here? From your description,
it would seem to be the ideal solution. The formulas in the chart table
could be wrapped in an IF() function that would test for whether data
exists yet, and would return NA() if the data doesn't exist. I can't be
specific because you have not given enough information, but you would
probably use ISNUMBER() or COUNT() to determine if there is data.
Alternately, you could compare the month to TODAY() to determine whether
data should exist.

Jerry
 
Back
Top