XL97: Inserted Objects on Charts Are Not Redrawn Correctly

ID: Q187934

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, an object that is on a chart that is on the same worksheet as a PivotTable may not be updated when you pivot the data in the PivotTable.

CAUSE

This problem may occur when the following conditions are true:

You create a PivotTable.
```
    -and-
```
You insert a chart that is based on the data in the PivotTable on the same worksheet as the PivotTable.
```
    -and-
```
You insert an object in the chart.
```
    -and-
```
You pivot the data in the PivotTable.

WORKAROUND

To display all the objects on the chart, Microsoft Excel must redraw the active screen. To do this, click the chart or update the PivotTable (click Refresh Data on the Data menu).

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows.

MORE INFORMATION

For additional information, please see the following articles in the Microsoft Knowledge Base:

   ARTICLE-ID: Q168965
   TITLE     : XL97: Scrolling in Chart Causes Text Boxes to Disappear

REFERENCES

For more information about creating a chart from a PivotTable, click the Office Assistant, type "charts from pivot tables," click Search, and then click to view "Create a chart from a pivot table."

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q120802
   TITLE     : Office: How to Add/Remove a Single Office
               Program or Component

Additional query words: XL97 imbedded imbed update updated redrawn redraws embed embedded

Keywords          : kbdta kbchart
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: November 1, 1998