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.