Microsoft KB Archive/187934

= XL97: Inserted Objects on Charts Are Not Redrawn Correctly =

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.



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

