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.

excell charting problem with false values
 

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 wrote in message
...
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.

excell charting problem with false values
 

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 wrote in message
...
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.