Archive for Friday, April 25th, 2008
Dynamic Chart using Pivot Table and VBA
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
In Using Pivot Table Data for a Chart with a Dual Category Axis, I showed how to make a Chart with a Dual Category Axis using a pivot table to properly arrange the source data. I generally prefer using a regular chart, because pivot charts are pretty inflexible when it comes to formatting. Unfortunately, a [...]
Posted: Friday, April 25th, 2008 under Charting Principles, Data Techniques, Dynamic Charts, Example Charts, Pivot Tables, VBA.
Comments: 7
