What value (from a function) would a chart line ignore (like it ignores an empty cell)?

H

Hansi

When creating a line chart, I would like to show separate bits of a
line (i.e. a discontinous line). The underlying data comes in the form
of excel formulas. Neither "" or FALSE does the job (both render a
zero-value when charting). I would like to avoid running a macro that
deletes the appropriate cells. Is there any solution for this in
today's excel version? Many thanks for your help!
 
J

Jon Peltier

By itself, this won't show a discontinuous line. It draws the line from
one side of the NA() to the other.

Tushar Mehta (http://tushar-mehta.com) has a routine on his web site
that turns these NA values into true worksheet blanks, which become gaps
in the chart.

- Jon
 
Top