Share this Page URL

Chapter 11. Analyzing Data with PivotTab... > Formatting a PivotTable and Setting ... - Pg. 395

Analyzing Data with PivotTables and PivotCharts 395 5. 6. 7. Click one of the Sum Of Commission columns in the PivotTable. (You don't need to close the Properties dialog box before you click the column.) Change the caption from Sum of Com- mission to Commission. Use the buttons and lists in the Format area to change the appearance of the caption. Click the Format tab, and then select Microsoft Office PivotTable 10.0 from the Select list.