Microsoft KB Archive/304167

= ACC2002: How to Create a PivotChart View That Does Not Summarize Data =

Article ID: 304167

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q304167



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SUMMARY
This article shows you how to create a PivotChart view that displays detail data instead of summarized data. By default, when you drag fields to the data fields area, the PivotChart view of an object displays summarized data. Sometimes, however, you may want to have the PivotChart view display actual detail records instead of summarizing them. For an example of how to do so, follow these steps:
 * 1) Open the object in PivotChart view.
 * 2) On the View menu, click Properties.
 * 3) On the General tab of the Properties dialog box, set the Select box to Chart Workspace.
 * 4) On the Data Details tab, select the Plot detail records check box. If you have already dragged fields to the PivotChart list, you will receive a message that the PivotChart layout will be cleared in order to continue. Click Yes.
 * 5) If you have not yet dragged fields to the data area of the PivotChart list, drag the fields to the data area.

Additional query words: inf pivotchart

Keywords: kbhowto KB304167

-

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

© Microsoft Corporation. All rights reserved.