Excel: Pivot Charts from Detail Data in Excel 2013

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.


Say that you have hundreds of rows of detail data. Select the entire data set and use Insert, Recommended Chart. Excel will recommend that you let it create pivot charts to summarize the data. You will see tiny Pivot icons on each chart tile.