I have some formulas that return empty strings if certain conditions
exist. The intention is that charts NOT show data in these cases.
Yet, they show up as zeros. I've read on here about the use of NA(),
and that works fine, but then if I have another formula that looks at
these values for the maximum value (of the data series, to
automatically adjust the max scale), it won't work because of the NA()
error.

What I would like is to have the empty string values NOT appear in the
chart, and I'm wondering if there's another solution other than
forcing the use of NA()??

Any suggestions appreciated.


Paul Martin
Melbourne, Australia