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

Chapter 10. Analyzing Worksheet Data > Modifying a PivotTable and PivotChart

Modifying a PivotTable and PivotChart

You can modify PivotTable or PivotChart reports. With Excel's AutoFormat feature, you can quickly format a PivotTable to create professional looking reports. You can also change field settings to format a number or show the data in a different form. The field settings include functions such as Sum, Count, Average, Max, and Min. If you want to set different scenarios, you can also hide fields while you change field settings.

AutoFormat a PivotTable Report

Click any field in the PivotTable report.

Click the Format Report button on the PivotTable toolbar.

Click the AutoFormat style you want.

Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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