Excel: How to create (truly) blank cells from formula so that they wont show up in a chart?
Excel: How to create (truly) blank cells from formula so that they wont show up in a chart?
Excel: How to create (truly) blank cells from formula so that they wont show up in a chart?
Re: Excel: How to create (truly) blank cells from formula so that they wont show up in a chart?
Found the answer [here](https://stackoverflow.com/questions/1119614/return-empty-cell-from-formula-in-excel). If you make the formula return `NA()` instead of `""`, the chart will accept it as empty and not display a line.