Microsoft KB Archive/302672

= The &quot;Plot Empty Cells as Interpolated&quot; option is unavailable in Excel =

Article ID: 302672

Article Last Modified on 6/5/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q302672





Microsoft Office Excel 2007
The Connect data points with line option is unavailable unless all series on the chart are plotted as lines.

Note On the Design tab, click Select Data in the Data area, and then click Hidden and Empty Cells on the Select Data dialog box.

Microsoft Excel 2002 or Microsoft Excel 2000
The Plot empty cells as Interpolated option is unavailable unless all series on the chart are plotted as lines.

NOTE: To view this option, click Options on the Tools menu, and then click the Chart tab.



WORKAROUND
To work around this problem on a single chart, use a Microsoft Visual Basic for Applications (VBA) macro to enable the feature. To do this, follow these steps:  Select the chart on which you are experiencing the problem. Press F11 + ALT to open the Visual Basic Editor. In the Project Explorer, select the project that you are working on. On the Insert menu, click Module.

Excel inserts a new code module and displays its Code window on the right side of the screen.  Type the following macro in the Code window: Sub MyInterpolate ActiveChart.DisplayBlanksAs = xlInterpolated End Sub  On the File menu, click Close and Return to Microsoft Excel.</li> On the Tools menu, point to Macro, and then click Macros.</li> In the list of macros, click MyInterpolate, and then click Run.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="references_section">