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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems with an If function 4
Data Validation with Blank Date 2
How do I automatiicaly redefinie Source data range for a chart? 1
crazy triple array formula 3
2003 Excel Chart with zero data 5
pivot table calculated field or item 4
Chart displaying "blank" cells? 13
Macro deletes row in range, macro then skips the row moved up 7

Back
Top