How to chart #NUM!
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ali Baba" wrote in message
...

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.

Thank you very much Bernard. This has solved the problem

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ali Baba" wrote in message
...

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.