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

Chapter 20. 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 the PivotChart to look a different way 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 2000, 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.

Using the PivotTable Toolbar

The PivotTable toolbar enables you to create a PivotTable layout by dragging the fields from the toolbar to the drop zones of the PivotTable. Table 20.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