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

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