Share this Page URL

Chapter 11. Analyzing Data with PivotTab... > Showing PivotTables and PivotCharts ... - Pg. 405

Analyzing Data with PivotTables and PivotCharts 1. 2. 3. 4. 405 In the Database window, select the form named ProductsByCountry_PivotTable, and then click Edit, Copy. Click Edit, Paste. In the Paste As dialog box, enter ProductsByCountry_PivotChart as the new form's name. Select ProductsByCountry_PivotChart in the Database window, and then click Design. If the Properties dialog box isn't open, click the Properties button on the toolbar. On the Format tab, shown here, set the Default View property of the form to PivotChart: 5. 6. Save the changes to the form, and then close it. In the Database window, select the form named ShowPivotViews, and then click Design. The ShowPivotViews form, shown here, includes a subform control. The Source Object prop- erty for the control is set to the ProductsByCountry_PivotTable form. If you want to check the setting for this property, open the Properties dialog box, select the subform control, and look at the Source Object property on the Data tab.