excell charting problem with false values

I have the following formula =IF(AND(BU2<$BU$1110,BU2>$BU$1111),BU2,"") chart
shows 0's for false empty value "" I would like to skip false or format so
that value doesn't get charted.

Replace 'nothing' with N/A which gets ignored by chart.
=IF(AND(BU2<$BU$1110,BU2>$BU$1111),BU2,NA())
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ricky Ray" <Ricky Ray@discussions.microsoft.com> wrote in message
news:44FC3775-2804-4167-BF87-01EE74E1A291@microsoft.com...
>I have the following formula =IF(AND(BU2<$BU$1110,BU2>$BU$1111),BU2,"")
>chart
> shows 0's for false empty value "" I would like to skip false or format
> so
> that value doesn't get charted.

Thanks for the input. This solution created another problem. Now the
formulas at the bottom of this column stdev, average do not compute. Any way
to have both graphing and computation without creating a new column?

"Bernard Liengme" wrote:

> Replace 'nothing' with N/A which gets ignored by chart.
> =IF(AND(BU2<$BU$1110,BU2>$BU$1111),BU2,NA())
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Ricky Ray" <Ricky Ray@discussions.microsoft.com> wrote in message
> news:44FC3775-2804-4167-BF87-01EE74E1A291@microsoft.com...
> >I have the following formula =IF(AND(BU2<$BU$1110,BU2>$BU$1111),BU2,"")
> >chart
> > shows 0's for false empty value "" I would like to skip false or format
> > so
> > that value doesn't get charted.
>
>
>