Chart that Ignores N/A! Errors and Empty Values
![data table data table](../wp-content/easy-excel/Empty/data table.png)
![mark data table mark data table](../wp-content/easy-excel/Empty/mark data table.png)
![insert ribbon insert ribbon](../wp-content/easy-excel/Empty/insert ribbon.png)
![ribbon line chart ribbon line chart](../wp-content/easy-excel/Empty/ribbon line chart.png)
Click on 2-D line chart.
Right click on the series with a break (1), and choose “Select Data” (2).
Click hidden and empty cells
Check zero, and then press ok.
Press ok The new chart:
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References