charting blank cells....

  • Thread starter Thread starter ojv
  • Start date Start date
O

ojv

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

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