Introduction to the
Office PivotTable List
While multiple options
exist for creating a PivotTable List, one of which involves starting by
creating a PivotTable Report in Excel (complete with data source setup),
and then transforming it into a PivotTable List, we will focus upon the design
and creation of a PivotTable List "from scratch" in this lesson. We
will use FrontPage 2002 as the application from which we can not only to read
the PivotTable List (just as a browser would), but from which we can also
design and/or edit the PivotTable List and apply our changes for immediate
effect. Microsoft FrontPage 2002, which is included in the Premium Edition of
Office XP, (and is sold separately, and is available in other ways), is well
suited to the purpose of creating PivotTable Lists due to its integration with
in FrontPage 2002
Let's start FrontPage 2002, and set
about the PivotTable List design process.
Click the Start button.
Select Programs -` FrontPage
FrontPage 2002 opens, and a new, blank
page appears. (If not, simply click the "New" button to create
a new page).
Choose Insert from the
Select Web Component, as
shown in Illustration 1.
Illustration 1: Select Web
The Insert Web Component selection dialog appears.
Under Component Type
(left pane of the dialog), click Spreadsheets and Charts.
From the Choose a Control
options that appear in the right pane, select Office PivotTable as shown
in Illustration 2 below.
Illustration 2: Selecting
the Office Pivot Table Control
Click Finish to enact
The empty Office PivotTable List
appears in the new page, as shown in Illustration 3.
Illustration 3: The
Empty PivotTable List