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 table

Note: 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 table

Click insert in the Microsoft Excel.

insert ribbon

Click 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

You can download free chart template here