excell charting problem with false values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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