Access.2007.VBA.Bibl..

4. Open the newly created worksheet in Excel.


5. Click anywhere in the data range, select the Insert tab of the Ribbon, and select
   PivotChart from the drop-down in the Tables group, as shown in Figure 12.10.

FIGURE 12.10

Creating a PivotChart from data in an Excel worksheet.

6. The Create PivotTable with PivotChart dialog opens, as shown in Figure 12.11, with the
   range preselected; just click OK to create the PivotChart in another worksheet in the
   same workbook.

Going Beyond the Basics 12