Microsoft Office Tutorials and References
In Depth Information
Unlinking a pivot chart from a pivot table
Unlinking a pivot chart from a pivot table
In some cases, you may want to create a permanent copy of your pivot chart — a chart
that is no longer attached to a pivot table. One option is to create a picture of the
chart (refer to Chapter 3). The resulting picture will be a static object that cannot be
edited as a chart.
Another option is to delete the associated pivot table. You must do this by
deleting the sheet or by deleting entire rows or columns (simply deleting the cells in a
pivot table won’t work). When the pivot chart’s source data is no longer available,
Excel converts the pivot chart to a standard chart and each data series in the chart
uses arrays (not ranges).
If you delete a pivot table and the associated pivot chart contains a large
number of data points, Excel may display a confusing message: The text
string you entered is too long. Reduce the number of characters used or cancel
the entry . You’ll get this message every time you click the chart’s series. This
error is due to the fact that a chart SERIES formula is limited to 1,024
characters. The chart continues to display all the data, but the annoying error
message never goes away.
Creating a standard chart from a pivot table
Some users are frustrated by the fact that Excel does not allow you to create a
standard chart from the data in a pivot table. Even if you select a portion of the data
before you create a chart, Excel still creates a pivot chart. Why is this an issue?
Pivot charts have some limitations. For example, a pivot chart cannot be an XY
chart or a bubble chart. And, you don’t have as much control over formatting.
This section describes four methods that you can use to create a standard chart
from the data in a pivot table.
Method 1: Copy the pivot table data
to another part of your worksheet
If you select an entire pivot table and then use standard copy/paste techniques, the
result will be another pivot table. One alternative is to select only a portion of the
pivot table before you copy it. The result will be a static range of cells, and you can
use this range to create a chart.
If you would like to duplicate all of the data in a pivot table, use these steps:
1. Select the cells that make up the pivot table.
2. Choose Edit
Search JabSto ::

Custom Search