Excel: Creating the Power Pivot Table

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

The Pivot Table dropdown offers 8 choices and most of them are fairly silly. PivotTable and Pivot Charts are obviously needed. Pivot table pros will love the Flattened PivotTable. But all of those choices in the middle are redundant. They are trying to tell you that you can combine a pivot table and a chart on the same worksheet. You already know this.

Plus, this menu might make someone think that these are the only options. It is fine to have three charts in a horizontal row and a pivot table vertically below those.

In real life, build your pivot tables and charts one at a time. The first can go on a new worksheet. The others can go on the existing worksheet.

The eighth choice is cool; a flattened pivot table is one where the row labels automatically repeat, and the outer row fields don't have subtotals. This is great for creating a summary table that will be used for future analysis

  1. One, two, or four tables and charts.

For more resources for Microsoft Excel