turen -

Right-click a point of the data series, choose Select Data from the shortcut
menu, on the Select Data Source dialog box click Hidden and Empty Cells,
click (Show empty cells as:) Connect data points with line, click OK, and
click OK.

- Mike Middleton
http://www.DecisionToolworks.com


"turen" wrote in message
...
The data points will not connect in a line chart due to missing data in
between. I see a thread where you can solve this problem by selecting the
interpolation option in Tools menu Options Chart tab. But I can not
find
this Chart tab options under Excel option in Excel 2007. Could someone
please tell me how to deal with this problem in Excel 2007? Thank you
very
much.

turen