This is because a new setting has been introduced in Excel 2016 which is applied by default to new charts created by Create or native office.
How to fix
• Right click on chart.
• Click “Select Data”.
• Click the “Hidden and Empty Cells” button.
• Uncheck the “Show #N/A as an empty cell” checkbox.
• Click the “OK” button.