Database Reference
In-Depth Information
F I g u R e 11 - 3 4
Excel Ribbon interface to add a pivot chart
Choose Existing Worksheet and Use an External Data
Source. Click Choose Connection, as shown in Figure 11-35.
The choice of a connection is a bit different between Excel
2013 and earlier versions. In the earlier versions, you select
PowerPivot as the data source, but in Excel 2013 you must
choose Tables and then select Tables in Workbook Data
Model, as shown in Figure 11-36.
F I g u R e 11 - 3 5
Choosing a connection for a pivot
chart
F I g u R e 11 - 3 6
Choosing a connection in Excel 2013
