Recently, we rleased a big UserVoice request that customers have been asking for over the last several years, https://support.office.com/en-us/article/Display-empty-cells-null-N-A-values-and-hidden-worksheet-data-in-a-chart-a1ee6f0c-192f-4248-abeb-9ca49cb92274?ui=en-US&rs=en-US&ad=US. Thank you to those who voted and have been patiently waiting. These updates are available as part of an https://products.office.com/en-us/buy/compare-microsoft-office-products. If you are an Office 365 subscriber, https://support.office.com/en-us/article/How-do-I-get-the-newest-features-in-Office-2016-for-Office-365-da36192c-58b9-4bc9-8d51-bb6eed468516. There's quite a lot of excitement around the feature! The new functionality proves to be the greatest value for line and scatter charts as they're the most commonly chart used in Excel documents.
What problem did we fix?
The https://support.office.com/en-us/article/How-to-Correct-a-N-A-error-a9708411-f82e-4e1b-8a7e-28c28311b993error is produced when a formula can't find what it's been asked to look for. It is also produced from the function https://support.office.com/en-us/article/NA-function-5469C2D1-A90C-4FB5-9BBC-64BD9BB6B47Cwhich indicates no value is available. With the following dataset, #N/A is currently shown in a line chart as a connecting line. We've added the functionality for #N/A to be rendered as a blank.
How can I access the feature?
In the August update, you should see the option to control the behavior for #N/A: Chart Tools> Design tab > Select Data button > Hidden and Empty Cells button.
Thanks for reading!
