Click the chart to activate it
In the Design tab of Chart Tools, click Select Data
A dialog box opens, look at lower left corner for "Hidden and Empty Cells"
button and click it
You get three options: gaps, zero and connect.
Alternative (works in all version of Excel); in the empty cell type =NA().
It will display as #N/A and will be ignored by the chart engine
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"BABs" wrote in message
...
XL 2007 doesn't have the TOOLS-Options-Interpolate menu and choices.
This goes for a line chart as well.
Thx