4. Formatting Your Pivot Table Report

In this Chapter

Using AutoFormat 55

Applying Your Own Style 58

Setting Table Options 61

Using AutoFormat

Although it may sound a bit trivial, formatting can be an important aspect of creating a pivot table report. Pivot tables make it very easy to produce reports that summarize data by three, four, five, or more fields. When you start to show this many fields on a two-dimensional piece of paper, the totals can get very busy. Besides giving your pivot table reports a professional look and feel, formatting can have an illuminating effect on reports that are convoluted by large amounts of data. The right formatting can make your pivot table reports easier to read and improve the clarity of your data.

One of ...

Get Pivot Table Data Crunching now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.