Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Using Pivot Charts
However, the data in your pivot table is part of a larger object. The pieces of data you see inside your
pivot table aren’t individual pieces of data that occupy individual cells. Rather, they are items inside a
larger pivot table object that is occupying space on your worksheet.
When you create a chart from your pivot table, you’re not feeding it individual pieces of data inside
individual cells; you’re feeding it the entire pivot table layout. Thus your pivot chart can interactively
add, remove, filter, and refresh data fields inside the chart just like your pivot table. The result of all
this action is a graphical representation of the data you see in your pivot table.
If you’re new to Excel charts, we highly recommend you first read through Part II of this
Creating a pivot chart
To see how to create a pivot chart, look at the pivot table in Figure 15-1. This pivot table provides a
simple view of revenue by market. In the Business Segment field in the report filter area, you can
parse out revenue by line of business.
Figure 15-1: This basic pivot table shows revenue by market and allows for filtering by line of business.
To start the process, place your cursor anywhere in the pivot table, go to the Ribbon, and click the
Insert tab. Find the Charts group, where you can choose the chart type you want to use for your pivot
chart. For this example, click the Column Chart icon and select the first 2-D column chart, as
demonstrated in Figure 15-2. A chart appears, as shown in Figure 15-3.
Notice that pivot charts are now, by default, placed on the same sheet as the source pivot table. If
you long for the days when pivot charts were located on their own chart sheet, you are in luck. All
you have to do is place your cursor in your pivot table and then press F11 on your keyboard, and a
pivot chart is created on its own sheet.