Chapter 9 Creating Dynamic Lists with PivotTables

Creating Dynamic Lists with PivotTables To create a PivotTable

  1. Click any cell in the data list.

  2. On the Data menu, click PivotTable and PivotChart Report.

  3. Ensure that the Microsoft Excel list or database option button is selected in the top pane, identifying your worksheet as the data source, and that the PivotTable option button is selected in the bottom pane.

  4. Click Next to move to the next page of the wizard.

  5. Ensure that the proper cell range appears in the Range box.

  6. Click Next to move to the next page of the wizard.

  7. Click Finish.

  8. From the PivotTable Field List dialog box, drag the fields for the horizontal axis to the Drop Column Fields Here box.

  9. From the PivotTable Field List dialog box, drag the fields ...

Get Microsoft® Office Excel® 2003 Step by Step 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.

Start your free trial