Microsoft KB Archive/305585

= OFFXP: Office Web Components Chart Component Based on PivotTable Does Not Display All Data =

Article ID: 305585

Article Last Modified on 1/6/2006

-

APPLIES TO


 * Microsoft Office Web Components

-



This article was previously published under Q305585





SYMPTOMS
When you use the Microsoft Office XP Web Components to create a PivotTable Web component and a chart Web component, the chart may not display all of the information from the PivotTable that the chart is linked to. Specifically, the data field may not be displayed.



CAUSE
This problem occurs when you drag the PivotTable fields from the field list into the data areas of the PivotTable.



WORKAROUND
To work around this problem, use one of the following methods.

Method 1: Use the &quot;Add To&quot; Button When You Create the PivotTable
To avoid this problem, use the Add To button in the PivotTable field list to add the fields to the PivotTable when you create it.

Method 2: Add the Data to the Chart Manually
After you create the chart, click the Field List button on the toolbar to display the fields that are available. Select the field that is missing from the chart, and then drag it to the area where you want to add it.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: OFFXP OWC pivot table

Keywords: kbbug kbnofix KB305585

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.