Microsoft Office Tutorials and References
In Depth Information
Creating a PivotChart
As you can see, when it comes to PivotCharts, Excel does almost all the grunt work for you. All
you need to do is tell Excel that you want a PivotChart, and what type of chart you want, and your
chart will be produced with its accompanying PivotTable.
There is a lot more you can do with PivotCharts and PivotTables, like many
other topics, it’s one that can ill an entire book. My objective so far in the lesson
is to cover the basics of creating and working with PivotTables as a foundation
for the VBA examples in the next sections.