Now, from within Excel, our first test report from PowerPivot can be constructed. Select the PowerPivot ribbon item to show the PowerPivot-specific Excel operations. From the Report section of the PowerPivot ribbon, select the PivotTable drop-down and the PivotChart item. This operation is illustrated in Figure 1-6.
Figure 1-6. Inserting a PivotChart
From the ensuing dialog, select New Worksheet as the destination. This will render the PowerPivot Field List on the right-hand side of the worksheet. From the field list, drag Product into the area in the lower left-hand corner of the PowerPivot field list, which is labeled Axis Fields. Similarly, drag the Quantity item into the lower right-hand area of the PowerPivot field list, labeled Values. If the software is installed correctly and the instructions followed precisely, you should have a chart similar to Figure 1-7.