Page 717 - Excel 2013 All-in-One For Dummies

Using the PowerPivot and Power View Add-Ins 699
can’t install this very large library of software code describing network com- munications on your device, you must import the data for your pivot tables from these two sources in the Excel program window, using the appropriate options on its Get External Data button’s drop-down menu found on the Data tab of its Ribbon.
Switching between the Data View and Diagram View
Diagram View is among the most useful features for data modeling offered by the Excel 2013 PowerPivot add-in. When you switch from the default Data View to Diagram View either by clicking the Diagram View button on the Ribbon or the Diagram button in the lower-right corner, all the data tables used in the Data Model are graphically displayed in the PowerPivot window. (See Figure 2-18.)
Figure 2-18:
Switching from Data View to Diagram View in the PowerPivot for Excel window.
Book VII Chapter 2
Generating Pivot Tables