Excel: How to create (truly) blank cells from formula so that they wont show up in a chart?
Found the answer here. If you make the formula return NA() instead of "", the chart will accept it as empty and not display a line.
Use #N/A to make the chart display blanks in a formula =IF(A1="",#N/A,A1) =IFERROR(A1,#N/A)