How do I prevent Excel from plotting a cell w/ a formula as a "ze.

[Guest]

I am setting up a trend chart for 2005 and want to setup the chart now so
that it updates each week as data is added. The problem I am having is that
the chart is plotting all future "result" cells as "zeros" because of the
formula in each cell. I am blanking out all future "result" column cells w/
(IF) logic statements w/ the (ISBLANK) function so nothing appears in the
cell until the right date, but its still being plotted as a zero. Is there a
way to prevent Excel from plotting these "formula only" cells as "zeros"?

 

[Guest]

Hatchet_Jack,

Try a reference to "NA()" or "=NA()" somewhere in your formula where the
result needs to be zero. Excel will not chart values where "NA()" or "=NA()
is referenced.