Microsoft Office Tutorials and References
In Depth Information
Method 4: Copy the pivot chart to a different workbook
Method 4: Copy the pivot chart
to a different workbook
Activate your chart and choose Edit
Copy. Then activate a worksheet in a different
workbook and choose Edit
Paste. The pasted chart will be unlinked from the pivot
table. If you examine the chart’s SERIES formulas, you’ll find that they contain
arrays, not cell references. Because there is a limit to the length of a SERIES
formula, this technique may not work if the chart uses a large amount of data.
Pivot Chart Examples
This section presents three additional examples of pivot tables and pivot charts.
Pivot charts, by their very nature, are interactive charts. Chapter 7 discusses
other ways to create interactive charts.
Creating a quick frequency distribution chart
The example in this section describes how to use a pivot table to create a frequency
distribution chart, sometimes known as a histogram. This technique works with
values and text.
Figure 9-19 shows a workbook with ratings from a survey item. Column A
consists of the respondent number (from 1 to 192), and column B contains the rating.
The objective is to create a frequency distribution chart that shows the number of
each Rating response.
To create the frequency distribution chart:
1. Select any cell in columns A or B.
2. Start the PivotTable and PivotChart Wizard and then choose the option to
create a pivot table and a pivot chart.
3. In Step 3, click the Layout button.
4. Drag the Rating button to the Row field and to the Data field.
5. Click Finish to create the pivot table and the pivot chart.
Figure 9-20 shows the pivot table and pivot chart (the field buttons are removed
from the pivot chart). Note that the Rating items are listed in alphabetical order in
the pivot table. To change the order of the items, you can just click an item and
drag it to a new position. The pivot chart will adjust accordingly.