• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 24. Using PivotTables and PivotC... > Modifying PivotTables and PivotChart...

Modifying PivotTables and PivotCharts

After you create a PivotTable or PivotChart, you can restructure the PivotTable or PivotChart to look different by dragging and dropping fields, or by using the options on the menus or the PivotTable toolbar. You also can change the look or structure of the PivotTable with formatting options (see the earlier section “Applying AutoFormats”). Because of the new options available with PivotTables in Excel 2002, you can adjust and manipulate just about all aspects of the PivotTable or PivotChart. You can apply colored fills, borders, and font colors just as you would a regular table on a worksheet. PivotCharts are a bit more difficult to format because of sizing limitations on the plot area and legend locations, but for the most part, they're as flexible as charts created with the standard charting features. When the structure of the PivotChart changes, so does its corresponding PivotTable (and vice versa).

Using the PivotTable Toolbar

The PivotTable toolbar enables you to modify and refresh the selected PivotTable or PivotChart. Table 24.1 describes the options available on the toolbar.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint