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
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.
On the Insert tab, click PivotTable to open the Create PivotTable dialog box.
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.
Click OK to create the PivotTable on a new worksheet.
In the PivotTable Fields pane, drag the Volume field header to the Values area.
Drag the Weekday field header to the Columns area.
Drag the Center field header to the Rows data area.
CLEAN UP Close the Imported Data workbook, saving your changes if you want to.