Chart that Ignores N/A! Errors and Empty Values

We will create a chart that ignores both N/A! and empty values. For you to create that, you need a data that has the two of them, which looks like this:
data tableNote: The result in earning column is with the help of IF function, as you could see in the formula bar, and the 0,6875 is price of product. Mark relevant cells for the chart.mark data tableClick insert in the Microsoft Excel.insert ribbonClick on the line chart.ribbon line chart

Click on 2-D line chart.

2d line chart

Right click on the series with a break (1), and choose “Select Data” (2).

select data

Click hidden and empty cells

hidden empty cells

Check zero, and then press ok.

zero ok

Press ok The new chart:

line chart ready

Template

You can download the Template here – Download