Microsoft Office Tutorials and References
In Depth Information
Alternatives to Pivot Charts
If you have pivot field buttons on your chart, they will also show up in the copied
picture, which may confuse your audience about why the buttons don’t work. Be
sure to hide all pivot field buttons before copying a pivot chart as a picture. You
can remove them by clicking your chart and then selecting the Analyze tab. On the
Analyze tab, use the Field Buttons drop-down button to hide all of the pivot field
Create standalone charts that are connected
to your pivot table
To retain key functionality in your pivot table, such as report filters and top ten ranking, you can link a
standard chart to your pivot table without creating a pivot chart.
In the example in Figure 15-21, a pivot table shows the top ten markets by contracted hours along
with their total revenue. Notice that the report filter area allows you to filter by business segment so
you can see the top ten markets segment.
Figure 15-21: This pivot table allows you to filter by business segment to see the top ten markets by total
contracted hours and revenue.
Suppose you want to turn this view into an XY scatter chart to be able to point out the relationship
between the contracted hours and revenues. You need to keep the capability to filter out ten records
by model number; however, you also want the ability to create XY.
A pivot chart is definitely out because you can’t build pivot charts with certain chart types (such as
XY scatter charts). The preceding techniques are also out because those methods disable the
interactivity you need. So what’s the solution? Use the cells around the pivot table to link back to the data
you need and then chart those cells. That is, you can build a mini dataset that feeds your standard