Excel Dashboards & Reports For Dummies
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 senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community.

This article can be found in the category: