Agreed but the OP seems to have really empty cells (missing data)
But I should have added the formula proviso for the sake of others
Cheers
--
Bernard
"Jon Peltier" wrote in message
...
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