charting blank cells....

O

ojv

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

ojv
 
J

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/
_______
 
Top