Bob Jordan
My feedback

20 votesBob Jordan supported this idea ·

4 votes

4 votesBob Jordan supported this idea ·

12 votesBob Jordan supported this idea ·

5 votesBob Jordan shared this idea ·

2 votes1 comment · Excel for Mac » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →Bob Jordan supported this idea ·

16 votesBob Jordan supported this idea ·

730 votes98 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
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.
Thanks,
John [MS XL]An error occurred while saving the comment
Anyone doing statistical work has the need for a missing value and as noted none of the workarounds are good across plots and calcs. The only solution I have found is to have two columns  one to do the calculations and one for the plots. But this also has limitations in addition to the obvious duplication.
The NULL() is the obvious choice of all the error codes and i so strongly support this move.
I will post a comment through the Excel 'Send feedback' and suggest others do to.
Bob J.