Quick Reference—Create and Format a PivotTable
For easy reference, once you have the concepts down, follow these steps to create and manage the basics of PivotTable and PivotChart reports.
Create your data in columns, with a single row of headings and a value in every cell of the range. For best results, format your data range as an Excel table.
Click in the table and then, on the Insert tab, click PivotTable.
Just click OK in the Create PivotTable dialog box to accept the defaults and create your PivotTable on a new sheet, with the selected table as your source data.
On the new sheet, click to select the fields in the PivotTable Field List pane that you want to include in your PivotTable.
After your fields are added to the PivotTable Row Labels and ...
Get Advanced Microsoft® Office Documents 2007 Edition Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
