Chapter 16. PivotTables and PivotCharts

This chapter discusses how to create and manipulate PivotTables and PivotCharts using Microsoft Visual Basic for Applications (VBA). In this chapter, you will learn about the objects associated with PivotTables and PivotCharts and how to manipulate PivotTables and associated objects programmatically.

PivotTables and PivotCharts

Worksheets are a useful tool when you are dealing with two-dimensional data that can be organized into rows and columns. However, there are many situations where your data can be viewed in multiple ways. Although you could build multiple worksheets and charts based on the data ...

Get Microsoft® Office Excel 2003 Programming Inside Out 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.