Bernard -
Don't forget that the "Empty Cells" setting applies only to empty cells,
not cells containing "" or #N/A.
- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
Bernard Liengme wrote:
Have your tried enter =NA() in the blank cells? This displays as #N/A which
the chart engine ignores.
Also there is a chart option to specify that blanks are to be ignored and
points are to be joined.
In XL2003; click chart; open Tools | Options | Chart and locate area
specifying how blanks are to be treated
In XL2007: Chart Tools Design; Data group; Select Data tool -- at bottom of
dialog box "Hidden and Empty Cells"
best wishes