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

  • Thread starter Thread starter Hansi
  • Start date Start date
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!
 
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
 
Back
Top