Microsoft Office Tutorials and References
In Depth Information
Creating Pivot Charts
As soon you click OK after selecting the chart type, Excel displays two things
in the same worksheet as the pivot table:
✓ Pivot chart using the type of chart you selected that you can move and
resize as needed (officially known as an embedded chart — see Chapter
10 for details)
✓ PivotChart Tools contextual tab divided into three tabs — Analyze,
Design, and Format — each with its own set of buttons for customizing
and refining the pivot chart
You can also create a pivot chart from scratch by building it in a similar
manner to manually creating a pivot table. Simply, select a cell in the data
table or list to be charted and then select the PivotChart option on the
PivotChart button’s drop-down menu (select the PivotChart & PivotTable
option on this drop-down menu instead if you want to build a pivot table as
well as a pivot chart). Excel then displays a Create PivotChart dialog box with
the same options as the Create PivotTable dialog box (shown in Figure 9-3).
After selecting your options and closing this dialog box, Excel displays a blank
chart grid and a PivotChart Fields task pane along with the PivotChart Tools
contextual tab on the Ribbon. You can then build your new pivot chart by
dragging and dropping desired fields into the appropriate zones.
Moving pivot charts to separate sheets
Although Excel automatically creates all new pivot charts on the same
worksheet as the pivot table, you may find it easier to customize and work with it
if you move the chart to its own chart sheet in the workbook. To move a new
pivot chart to its own chart sheet in the workbook, you follow these steps:
1. Click the Analyze tab under the PivotChart Tools contextual tab to
bring its tools to the Ribbon.
If the PivotChart Tools contextual tab doesn’t appear at the end of your
Ribbon, click anywhere on the new pivot chart to make this tab reappear.
2. Click the Move Chart button in the Actions group.
Excel opens a Move Chart dialog box.
3. Click the New Sheet button in the Move Chart dialog box.
4. (Optional) Rename the generic Chart1 sheet name in the
accompanying text box by entering a more descriptive name there.
5. Click OK to close the Move Chart dialog box and open the new chart
sheet with your pivot chart.
Figure 9-10 shows a clustered column pivot chart after moving the chart to its
own chart sheet in the workbook.