Creating a Pivot Chart Report to Compare Data Between Years

Selecting a cell in the Data area of the PivotTable report and pressing <F11> creates a PivotChart report (new in Excel 2000 and later) in a new worksheet of the workbook.

Figure 13-12: PivotChart Report

The PivotChart report shown in Figure 13-12 has a Data Table at the bottom. Pressing <F11> does not automatically create a Data Table; to add it, follow the procedure below.

^ To add the option Show Data Table to the PivotChart report:

1. From the Chart menu, select Chart Options.

2. From the Chart Options dialog box, select the Data Table tab.

3. Select Show Data Table Option and click OK.

Chapter 13

0 0

Post a comment