Article ID: 187934
Article Last Modified on 10/19/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
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.
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
Additional query words: XL97 imbedded imbed update updated redrawn redraws embed embedded
Keywords: kbbug kbchart kbpending KB187934