O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required