Microsoft Office Tutorials and References
In Depth Information
Creating a PivotChart
As soon as you click OK, the chart appears, as
shown in Figure 15-24. Unlike a regular chart,
the PivotChart has buttons for your Report Filter
field/s, your Row Label field/s, and your Column
Label field/s. Plotted within the chart is the data
you added to the Values section of the PivotTable.
That said, there are things about PivotCharts
that require specific treatment. For example,
using the buttons that list your Report Filter,
Row, Column, and Value data.
How do you use them to change the PivotChart
as easily as you can change the PivotTable?
Change the Report Filter field. To do
this, click the button that lists the current
field by name. In Figure 15-25, you see
“Department,” and clicking that button
displays a list of the Department field
values you can choose from. Pick one
or more, and distill the chart down to
showing only data related to the
Department/s you choose. Note that if
you want to pick more than one item
from the list of Departments, you must
turn on the Select Multiple Items
checkbox (as has been done in Figure 15-25).
A PivotChart, based on your active
PivotTable, is instantly created.
To continue developing your chart—changing its
size and placement, formatting its bars, slices,
lines, and other components, and dressing it up,
you can refer to Chapter 11. There, you’ll find
out how to change the appearance of the chart
itself, because despite being a PivotChart, it’s
still a chart—that you can edit to use the colors,
fonts, and other graphical features you need to
use in order to make it look as polished as the
rest of your workbook. Remember, too, that your
PivotChart can be copied and pasted into any
Word document or PowerPoint presentation, so
you’ll need to make it look as good as possible.
Want your PivotChart to show less data?
Reduce the number of fields displayed
through the Report Filter field.