How to chart #NUM!

A

Ali Baba

I want to create a chart and in some cases I get #NUM!. If I plot the chart
#NUM! = 0, is there a way not to include the cells with those values.
 
B

Bernard Liengme

You #NUM! error must come from a formula. Let's say it is =A1/B1. Replace
this by
=IF(ISERROR(A1/B1),NA(), A1/B1) Now in place of the NUM error you will get
NA() and charts ignore this.
best wishes
 
Top