excell charting problem with false values

R

Ricky Ray

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.
 
B

Bernard Liengme

Replace 'nothing' with N/A which gets ignored by chart.
=IF(AND(BU2<$BU$1110,BU2>$BU$1111),BU2,NA())
best wishes
 
R

Ricky Ray

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?
 
Top