Line Chart treats blank cells as zero

  • Thread starter Thread starter Anders Wahlin
  • Start date Start date
A

Anders Wahlin

Hi!

I want to make a line chart from some columns. I have formulas in the cells
that either puts a value in them or just puts "" (blank) in them. Instead of
treating the blanks as zero I just want the chart to stop drawing the line.
How is that possible?

Regards
/Anders
 
Hi!

I want to make a line chart from some columns. I have formulas in the
cells that either puts a value in them or just puts "" (blank) in
them. Instead of treating the blanks as zero I just want the chart to
stop drawing the line. How is that possible?
Click to expand...

Try returning a textstring like "INVALID" instead of returning "".
 
"" is not blank. Formulas cannot return a true blank. #N/A, or
equivalently NA(), gets no plot symbol, but also does not break a line
connecting data points. That's as good as it gets without deleting the
formula entirely.

Jerry
 
Back
Top