Posted by
Andrian in
Data Analysis on
01 25th, 2009 |
no responses
Excel 2007 makes formatting a new pivot table you’ve added to a worksheet as quick and easy as formatting any other table of data or list of data. All you need to do is click a cell of the pivot table to add the PivotTable Tools contextual tab to the Ribbon and then click its Design tab to display its command buttons.
The Design tab on the PivotTable Tools contextual tab is divided into three groups:
- Layout group that enables you to add subtotals and grand totals to the pivot table and modify its basic layout
- PivotTable Style Options group that enables you to refine the pivot table style you select for the table using the PivotTable Styles gallery to the immediate right
- PivotTable Styles group that contains the gallery of styles you can apply to the active pivot table by clicking the desired style thumbnail
Picture below shows the pivot table created for the Employee Data List in previous example after applying the Pivot Style Medium 10 in the PivotTable Styles gallery to it. This style applies a light version of background color (rose) to the Gender Report Filter field and a darker version to the Values Label (Sum of Salary), Dept Column Labels, and Location Row Labels (so dark in fact, that Excel automatically reverses the label text to white).
Related Post
