Microsoft Office Tutorials and References
In Depth Information
Creating a PivotTable
Choosing Your PivotTable Data
As shown in Figure 15-2, the first dialog box you
see when you start making a PivotTable has some
very specific questions:
Tip
For Excel to automatically determine
which list you want to use, you only have
to activate one cell in that list before
clicking the PivotTable button on the
Insert tab. There is no need to select the
entire range of cells containing data—in
fact, the risk of your accidentally
omitting one or more rows of your data or the
header row in an attempt to manually
select the data first makes it worth it to
let Excel make its automatic decision as
to the range containing your list!
Select a table or range. This would
normally be a worksheet that you already
have open, which as shown in Figure
15-3, automatically includes all the records
in the active sheet. Excel detects a list in
the active worksheet and selects all the
records in it—as well as the header row,
where field names (column headings)
appear. If you want to use another
worksheet instead, click the sheet tab for the
worksheet containing the data you want
to work with, and then click and drag
through that data. The range you select
appears in the Table/Range box.
Choose where you want the PivotTable
report to be placed. Your choices here are
New Worksheet (this is the default, and
usually your best bet, so you’ll have lots of
elbowroom for your PivotTable) or Existing
Worksheet. If you opt for the latter, you
will need to specify which worksheet
should house your PivotTable-to-be. This
can be done by clicking the sheet tab
where the report should go, and once in
that sheet, clicking in the cell where the
report should begin. The sheet name and
cell address appear in the Location box
when you’ve made your selection.
Figure 15-3
Excel’s pretty intuitive—if your worksheet
contains a list, the list is automatically considered
to be the source of your PivotTable data.
Once you’ve told Excel which data you want to
use for the PivotTable and where the PivotTable
report should be placed, you’re ready to start
laying out the table, so click OK in the Create
PivotTable dialog box, and you’re on your way.
Use an external data source. This option
opens an Existing Connections dialog
box, through which you can tap into
linked data from the open workbook, or
use an MSN MoneyCentral database.
 
Search JabSto ::




Custom Search