O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

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

Using the PivotTable Web Component

Figure 30-45 shows the Books by Quarter PivotTable as published to the Web using the interactive PivotTable Web component. (For information about publishing Excel documents to the Web, see Chapter 20.) The user interface for the PivotTable Web component, unfortunately, differs strongly from Excel's own PivotTable user interface.

The PivotTable Web component's UI differs significantly from Excel's.

Figure 30-45. The PivotTable Web component's UI differs significantly from Excel's.

Here are some highlights to note:

  • To pivot the table, you can drag field headings between axes, as you can in Excel.

  • To remove a field from the table, right-click its heading and choose Remove Field from the ...

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