8. Creating Pivot Charts and Power View Dashboards

Pivot tables are the most powerful feature in Excel. A pivot table enables you to summarize a million records of transactional data in Excel with a few mouse clicks. A pivot chart is an extension of the pivot table concept. You start with detailed data, Excel summarizes that data in a pivot table, and then the summary data is charted.

Pivot charts are easier than ever to create thanks to the Recommended Charts feature in Excel 2013. You can go from a detailed data set to a summary chart in a few clicks. From there, even if the recommended chart is not exactly what you envisioned, you can ...

Get Excel® 2013 Charts and Graphs 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.