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.