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" <(E-Mail Removed)> wrote in message
news:711396FD-65FD-429B-9DB5-(E-Mail Removed)...
>
> 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" <(E-Mail Removed)> wrote in message
> news:711396FD-65FD-429B-9DB5-(E-Mail Removed)...
> >
> > 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.
> >
>
>
>