XL97: Inserted Objects on Charts Are Not Redrawn Correctly (187934)

The information in this article applies to:

Microsoft Excel 97 for Windows

This article was previously published under Q187934

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:

168965 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:

120802 Office: How to Add/Remove a Single Office Program or Component

Modification Type:	Major	Last Reviewed:	10/19/2000
Keywords:	kbbug kbchart KB187934