If the cell contains a formula, even one that returns "", it's not blank. It
contains a formula that returns a text item. Follow Bernard's instructions
for using NA().

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"MattBeckwith"
wrote in message
news:MattBeckwith.232y4b_1139686501.7405@excelforu m-nospam.com...

Bernard Liengme Wrote:
1) Click chart to activate it
Use Tools | Options; open Chart tab; specify how empty cells are to be
treated

Actually, I had already set it to not plot empty cells, but it does
anyway. It seems I can't attach an Excel file to this message, but if
you give me your email address I'll send it to you. My email address
is . Thanks.


--
MattBeckwith