Microsoft KB Archive/302672

Knowledge Base

The "Plot Empty Cells as Interpolated" 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

SYMPTOMS

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:

1. Select the chart on which you are experiencing the problem.
2. Press F11 + ALT to open the Visual Basic Editor.
3. In the Project Explorer, select the project that you are working on.
4. On the Insert menu, click Module.
   
   Excel inserts a new code module and displays its Code window on the right side of the screen.

5. Type the following macro in the Code window:

   Sub MyInterpolate()
     ActiveChart.DisplayBlanksAs = xlInterpolated
   End Sub
                       

6. On the File menu, click Close and Return to Microsoft Excel.
7. On the Tools menu, point to Macro, and then click Macros.
8. In the list of macros, click MyInterpolate, and then click Run.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

REFERENCES

For more information about how to use the sample code in this article, click the following article number to view the article in the Microsoft Knowledge Base:

290140 How to run the sample code for the Office XP programs from Knowledge Base articles

Additional query words: XL2007 XL2002 XL2000 dim dimmed grey greyed gray grayed out not available disabled

Keywords: kbbug kbpending KB302672

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.