Microsoft Office Tutorials and References
In Depth Information
Creating a PivotChart
Note the changes to the PivotTable
fields list panel. Instead of Column and
Row label fields, you now have Legend
and Axis fields. You still have Report Filter
and Values (which are plotted along the
vertical axis in a Column or Line chart),
but because it’s now a chart you’re
dealing with, the Row fields become the Axis
fields and the Column fields become part
of your Legend.
Change the focus of your PivotChart.
You can do this by making choices from
the Legend drop-down menu (see Figure
15-26, where Job Title appears) or the Axis
(LastName in this example) drop-down
menu (see Figure 15-27). Once you make
changes (choosing fewer or more items
from the lists to include in the chart), the
chart updates to show the requested data.
Reduce or expand the amount of data
plotted along the X (horizontal) axis.
PivotChart Data Changes
when PivotTable Data Does
It’s important to remember that whatever’s
in the PivotTable will be in the PivotChart.
If you change, add, or remove ﬁelds in the
PivotTable, the chart will update accordingly.
This doesn’t require any work on your part—
as far as the chart is concerned—unless your
changes create a problem in the easy or
logical interpretation of the chart. For example,
if you elected to do a Pie chart, adding
multiple ﬁelds to the Row or Column ﬁelds
could mean that there’s too much data to
plot in a single pie (as you learned in
Chapter 11, Pie charts can plot only one
data series at a time).
Choose which Legend data you want to
include in your PivotChart.