Error Trapping in Excel: How to use NA() to make your Excel chart pretty!
If you’ve ever used Excel to present data with ‘holes’ in it, you might have been frustrated by the options for how those holes should be represented on a chart. Here’s a short summary of one way to make the holes show up as missing data points rather than ‘0’, which might be confusing, inaccurate,…