Tom’s Tutorials For Excel: Programming the Anatomy of a Pivot Table and Pivot Chart
Here is a step by step example of how to program a pivot table and pivot chart, including how to place those objects exactly where you want them on your worksheet.
The programming code is in the downloadable workbook,
…