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.