Displaying Trend Data which includes zero values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christine Wilso - 29 Jul 2004 11:46 GMT

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

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Jerry W. Lewis - 29 Jul 2004 12:26 GMT

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

> I am creating trend charts which looks at monthly data from the year
> 2000. My data table is set up from April 2000 to March 2005. The charts
[quoted text clipped - 9 lines]
> to stop at the month to date rather than displaying a line of zero's
> from August to March 2005.

Reply to this Message