Need to return "Blank" cell but NOT NA()

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

For my chart, I need to return the equivalent of a
truly "blank" cell. The NA() function causes the graph to
interpolate the missing point, whereas a blank cell causes
the graph to plot nothing. I need to plot nothing.

I'm using layered lines, one dashed and one solid, so that
I can highlight interpolated points with a dashed style.

Currently, I use a white line to mask the solid line that
goes to "0" when the driving formula returns "" for the
solid line. This works in 90% of situations, but there
are some instances that are too complex (too many embedded
functions) to correct with a white line. I'd rather
correct the problem by preventing the solid line from ever
going to "0" in the first place, which can be accomplished
with a "blank" cell. Can this be done?
 
Eric -

I wish Excel had a BLANK() or NULL() worksheet function. Unfortunately
there are only semisatisfactory workarounds. Andy Pope has a workaround
on his web site, which I think is very much like your masking line, and
Tushar Mehta has a utility on his web site that also removes the line
generated by an NA(). I once wrote a routine that stepped through the
data in a chart, and if I got a certain kind of error, I knew the point
wasn't charted, so I turned off that segment of the line. That was a
long time ago, so I don't know where it might even be.

- Jon
 
Back
Top