Give us a proper NULL() worksheet function.
This would make calculations and charts treat a cell containing a formula as a blank cell, not as a cell with a text string ("") or as a zero.
Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.
John [MS XL]
you can use =NA() to return NA(), which is ignored by charts. This will break formulas though, so for charting it might be best to use a separate set of cells with something like =IF(A6="",NA(),A6)
Thanks for your feedback! We're reviewing your suggestion. Remember, the more votes a suggestion gets, the more likely it is that we'll do it.