Howdy. In regard to both questions, I wonder if it might be better to consider making the Pivot Table and Chart all in VBA. Bill Jelen, et al, VBA and Macros for MS Excel, chapter 12 have code examples and instructions about how to do all this.
The VBA approach gives you much more control, and in the long run can be faster than what you are trying now.
old, slow, and confused
but at least I'm inconsistent!