• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Analyzing Data with PivotTab... > Creating a PivotTable from External ...

Creating a PivotTable from External Data

You can create a PivotTable from selected fields and records of an external data source in either of two ways. If you've already set up a query to an external source using Microsoft Query (or its simplified front-end, the Query Wizard), you will see the dialog box shown in Figure 30-35 before the data appears in Excel. (For information about using Microsoft Query and the Query Wizard, see “Creating a New Database Query” on page 769.) Instead of selecting Existing Worksheet or New Worksheet in this dialog box, click the Create A PivotTable Report link. This link takes you to Step 3 of the PivotTable And PivotChart Wizard (refer to Figure 30-6). Tell the wizard where to put the table, lay out your fields, and you're finished.

Figure 30-35. If you've already set up a query, you can turn it into a PivotTable by clicking Create A PivotTable Report.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint