Microsoft Office Tutorials and References
In Depth Information
Creating PivotTables from external data
6
Verify that
Existing worksheet
is selected, and then click
OK
to import the data into
your workbook.
7
On the
Home
tab, in the
Styles
group, click
Format as Table
, and then click the first
table style to display the
Format As Table
dialog box.
8
Verify that the
My table has headers
check box is selected and that the range
=$A$1:$H$6571
appears in the
Where is the data for your table?
box, and then
click
OK
.
9
In the confirmation dialog box, click
Yes
to confirm that you want to create the Excel
table and break its link to the external data source. Excel creates an Excel table from
your imported data.
10
On the
Insert
tab, click
PivotTable
to open the
Create PivotTable
dialog box.
11
Verify that
Select a table or range
is selected, that
Table1
appears in the
Table/
Range
field, and that the
New Worksheet
option is selected.
12
Click
OK
to create the PivotTable on a new worksheet.
13
In the
PivotTable Fields
pane, drag the
Volume
field header to the
Values
area.
14
Drag the
Weekday
field header to the
Columns
area.
15
Drag the
Center
field header to the
Rows
data area.
10
CLEAN UP
Close the Imported Data workbook, saving your changes if you want to.
