Line charts with missing data points in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thank you very much!

Mike Middleton said:
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
Click to expand...
 
Back
Top