Chapter 13. Analyzing Data with Pivot Tables
When you create a spreadsheet, you have to be careful how you organize the columns and rows because that affects how you can sort, filter, or chart the data later. When you import data from an external source, such as a database, web query, SharePoint list, or CSV file, you usually don’t have a choice how the spreadsheet is organized—the data just comes in the way it was in the source.
Pivot tables let you reorganize data by dragging and dropping the columns from a data source to different locations on a target worksheet. You can then sort, filter, or chart the results as you like. That makes pivot tables Excel’s key data analysis tool.
This chapter includes task-oriented reference information for the following objects and their related collections: CalculatedField, CalculatedMember, CubeField, PivotCache, PivotCell, PivotField, PivotFormula, PivotItem, PivotItemList, PivotLayout, and PivotTable.
Tip
Code used in this chapter and additional samples are available in ch13.xls.
Get Programming Excel with VBA and .NET 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.
