Database Reference
In-Depth Information
Open OECDPopulationStats.xlsx . Switch to sheet 1, then start by clicking
the Pivot Chart button on the Insert Ribbon, as shown in Figure 12-23.
F I g u R e 12 -23 Excel Ribbon interface to add a pivot chart
Choose Existing Worksheet and Use an External Data Source. Click Choose
Connection, as shown in Figure 12-24.
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 12-25.
F I g u R e 12 -24 Choosing a connection for a pivot
chart
F I g u R e 12 -25 Choosing your workbook model
Search WWH ::




Custom Search