Page 137 - Excel Data Analysis

08 537547 Ch07.qxd 3/4/03 12:07 PM Page 123

WORKING WITH PIVOTTABLE REPORTS 7

You can select data for a PivotTable from the second page of the Wizard. See
multiple sources using the PivotTable and Chapter 8 for more on this option. The
PivotChart Wizard. The type of data you following table provides guidelines for
select determines which page displays as the different data types:

DATA TYPE DESCRIPTION
Excel List Limited to the size of 65,536 records, or rows. Each record can
have up to 256 fields or columns. The first row of an Excel list
must contain the column labels.
Database When you select the Database option on the first page of the
Wizard the second page lets you select the external database you
want to import into the data fields. See Chapter 5 for more
information on importing from a database.
Consolidation Ranges To use data values from multiple worksheets, you select this
option. On the second page of the Wizard, you specify each data
range separately. See Chapter 2 for more information on
consolidating data.
PivotTable or You select this option to use the same data that another PivotTable
PivotChart or PivotChart has. Excel only stores the data values once when both
share the same data, making the memory usage more efficient.

$A$1:$G$51

■ The second page of the ■ If the range of cells you ■ The third page of the ■ You can click Existing
Wizard displays. want does not appear in the Wizard displays. worksheet to place the
Range field, click Collapse PivotTable report in the
Á Verify that the correct Dialog Box button and select ° Click the New worksheet current worksheet and
range of cells appears in the the range. to place the PivotTable report specify the starting cell.
Range field. on a new worksheet.
‡ Click Next. · Click Layout.

CONTINUED
123