Microsoft Office Tutorials and References
In Depth Information
Alternatives to Pivot Charts
Figure 15-20: The Paste Values functionality is useful when you want to create hard-coded values
from pivot tables.
This action essentially deletes your pivot table, leaving you with the last values that were displayed in
the pivot table. These values can subsequently be used to create a standard chart.
This technique disables the dynamic functionality of your pivot chart. That is, your pivot chart
becomes a standard chart that cannot be interactively filtered or refreshed.
Delete the underlying pivot table
If you’ve already created your pivot chart, you can turn it into a standard chart by simply deleting the
underlying pivot table. To do so, select the entire pivot table and press Delete on the keyboard.
With this method, you are left with none of the values that made up the source data for the chart. In
other words, if anyone asks for the data that feeds the chart, you will not have it.
If you ever find that you have a chart but the data source isn’t available, activate the
chart’s data table. The data table lets you see the data values that feed each series in the
chart. See Chapter 7 to learn how to add the data table to a chart.
Create a picture of the pivot chart
A picture of your pivot chart freezes all of the text and numbers without any other information. In
addition to very small file sizes, you get the added benefit of controlling what your clients get to see.
To use this method, follow these steps:
1. Copy the pivot chart by right-clicking on the chart (outside the plot area) and selecting Copy.
2. Open a new workbook.
3. Right-click anywhere in the new workbook and select Paste Special; then select the picture
format you prefer.
A picture of your pivot chart is then placed in the new workbook.