charting blank cells....

[ojv]

Hi,
Under options choose chart and select the radiobutton
for not plotting blank cells, i.e. leave gaps.

ojv

 

[Jon Peltier]

This works for true blanks, but not for "" returned by a formula. It's not a blank, just a very
short piece of text. Frank's suggestion will work.

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