How to chart #NUM!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top