Microsoft Office Tutorials and References
In Depth Information
Creating a PivotChart
So your PivotTable isn’t enough to create
an easily digestible, here’s-my-data-and-what’s-
important-about-it view of your rows and rows
of information? Well, maybe a PivotChart will
help complete the picture you’d hoped to paint.
As discussed in Chapter 11, charts are a powerful
way to take lots of potentially boring or
confusing numeric data and turn it into a picture—a
picture that tells a simple story, like “Sales are
up in the third quarter!” or “Our managerial
salaries are quite high, compared to the rest of
the staff.” It stands to reason, therefore, that a
PivotTable, which already helps distill your data
down to the most important and dynamic pieces
of information, would be even more powerful if
it could also display your data as a picture.
Paint an even simpler picture of your
data with a PivotChart.
To create a PivotChart, of course you need an
existing PivotTable. With any cell in that PivotTable
active (to let Excel know which PivotTable you’re
using as the basis for your PivotChart), as soon
as you click the PivotChart button (from the Tools
section of the Options tab), the Insert Chart
dialog box appears (see Figure 15-23). Use
this dialog box to decide which kind of chart
you want to create. Pick one and click OK.
As shown in Figure 15-22, a PivotChart showing
the total salaries for each department in the
sample company takes the PivotTable to another
level. Not only do you see the amounts paid to
each department’s staff in the table, you see
them in a comparative Column chart in the
PivotChart. And unlike a static chart that only
changes if the data that went into it changes, a
PivotChart can be changed using the same filters
and sorting tools that change the display in the
PivotTable itself—even more flexibility!
3D? Columns? A Pie chart? Pick the type of chart
you want to build from your PivotTable data.