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.