Excel Dashboards & Reports for Dummies, 4th Edition
Book image
Explore Book Buy On Amazon

The Excel pivot tables you create often need to be tweaked to get the look and feel you're looking for. Excel gives you a choice in the layout of your data in a pivot table. The three layouts, shown side by side in the following figure, are Compact Form, Outline Form, and Tabular Form.

The three layouts for a pivot table report.
The three layouts for a pivot table report.

Although no layout stands out as better than the others, the Tabular Form layout seems easiest to read, and it's the layout that most people who have seen pivot tables are used to.

The layout you choose affects not only the look and feel of your reporting mechanisms but may also affect the way you build and interact with any dashboard models based on your pivot tables.

Changing the layout of a pivot table is easy. Follow these steps:

  1. Click anywhere inside the pivot table to activate the PivotTable Tools context tab on the Ribbon.

  2. Select the Design tab on the Ribbon.

  3. Click the Report Layout icon and choose the layout you like from the menu that appears.

    Changing the layout of the pivot table.
    Changing the layout of the pivot table.

About This Article

This article is from the book:

About the book author:

Michael Alexander is a Microsoft certified application developer and author of several books on advanced business analysis with Microsoft Access and Microsoft Excel. He has been named a Microsoft MVP for his ongoing contributions to the Excel community.

This article can be found in the category: