Microsoft Office Tutorials and References
In Depth Information
Using the PivotTable Tools
On the Design tab (shown in Figure 15-12), you
can determine what you see in the PivotTable
and how it looks. Here are your choices:
PivotTable Style Options. Here, use the
checkboxes to decide which things are
included—Row Headers, Column Headers
(both on by default), and whether or not
to use Banded Rows and Columns. If you
turn one or both of these on, the options
in the next bullet point, PivotTable Styles,
change to show banded options. Bands
are colored rows and/or columns to help
give your PivotTable a more graphical,
colorful look.
Layout. Choose which parts of the
PivotTable you want to see—Subtotals and
Grand Totals—and from their drop-down
menus, how they should look if they’re
displayed. The Report Layout option
allows you to show your PivotTable in
Compact, Outline, or Tabular format, and
to choose how your item labels appear.
PivotTable Styles. Click on a button for
any style that looks interesting—the use
of colors, number of bands (colored
rows/columns), and so on. Scroll through
the list of buttons and test any that look
interesting. Figure 15-13 shows one of
the styles in place.
Figure 15-12
Your PivotTable Design options are all housed
in the aptly named Design tab.
Figure 15-13
Colored bands in the top and bottom rows make
this PivotTable more interesting to look at and help
draw attention to the row and column labels.
Search JabSto ::

Custom Search