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

Chapter 24. Using PivotTables and PivotC... > Creating a PivotTable from Multiple ...

Creating a PivotTable from Multiple Ranges

Excel enables you to create PivotTables from multiple consolidation ranges by selecting the multiple consolidation option from Step 1 of the PivotTable and PivotChart Wizard. For example, if you have two companies with product sales or two divisions with product sales, you can establish separate worksheets or databases to control the list and then combine into a multiple consolidated PivotTable. (The wizard walks you through step-by-step.) Figure 24.42 shows Step 2b of 3 of the PivotTable and PivotChart Wizard, which enables you to select lists or ranges in any open documents. Drag over the range of data you want to consolidate and click the Add button to add it to the All Ranges section of the dialog box (see Figure 24.43 for the result).

Figure 24.42. To consolidate lists into a PivotTable, select the consolidation ranges in Step 1 of the wizard and add the ranges together.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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