Chapter 8. PivotTables and Pivot Charts
There's that word again—Tables. They're back, but this time we're going to look at tables from a different angle—almost literally—by subjecting all those columns and rows to a new and more informative way of presenting their data—the PivotTable.
PivotTables are a most powerful and nimble way to aggregate data—but that introduction calls for a bit of...well, introduction. After all, adding a column of numbers is a form of data aggregation, too, but you wouldn't bother to apply a PivotTable to that task (though you could). PivotTables do something else, something more. A lot more.
It's one thing to be able to total a range of numbers—even a very large range—and that can be a most important capability. But to ...
Get Beginning Microsoft Excel 2010 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.
