If the cells are truly blanks, try Tools menu > Options > Chart tab >
Show blank cells as... Not Plotted.
If the cells only look like blanks, such as formulas that return "",
change the "" to NA():
=IF(A1>0,A1,NA())
The NA() produces an ugly #N/A error in the sheet, but in line and
scatter charts they aren't plotted. Debra Dalgleish shows how to hide
the errors with conditional formatting:
http://contextures.com/xlCondFormat03.html#Errors
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______