Where is Excel’s missing ‘New’ Feature?


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

It was a small but long awaited addition to Excel for Windows but now it’s disappeared?  Why did the Chart option “Show #N/A as an empty cell” go missing?

There was a small cheer in the Excel charting community when Microsoft put this extra option in the Chart | Hidden and Empty Cell Settings:

img 59ee06c96f52e - Where is Excel's missing 'New' Feature?

‘Show #N/A as an empty cell’ stopped cells with #N/A results from messing up a perfectly good chart.

UPDATE:

It’s Back!  No word on why ‘Show #N/A as an empty cell’  went to, but it’s reappeared.

Certainly it’s in Office 2016 for Windows (Office 365) build 8528.2139 available in the last days of October 2017.  If your Excel doesn’t have the option, update your Office (File | Account | Office Updates | Update now.

Where is it?

The feature seems to have disappeared from both Insiders releases and the latest public versions too.

No matter where we look, the option is gone, AWOL, disappeared, missing, gone to meet the choir invisible etc.

where is excels missing new feature 15461 - Where is Excel's missing 'New' Feature?

Not everyone at Microsoft got the memo

The references to the extra Chart feature have been removed from the Office 2016 for Windows (Office 365)  What’s New pages. No explanation, let alone an apology.

But not everyone at Redmond got the memo.  This page about Empty and Hidden cells in Excel charts still references the dropped feature.

img 59ee06fe09f08 - Where is Excel's missing 'New' Feature?

We can even show you the Microsoft video for this non-existent feature.

Treat customers like adults

It would be too much to expect Microsoft to treat their customers like adults.  Explaining that the feature had to be dropped would save customers time and angst trying to figure out why an option isn’t there.

Alas, Microsoft only thinks of its own corporate ego.  It’s more important to show no mistake than consider the a customer’s needs and tolerance for honest mistakes.

subs profile e1563205311409 - Where is Excel's missing 'New' Feature?
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address