How do i add a command button (macro) to a Pivot Chart. As my doesn't allow me to select the command button from the Control Toolbox.

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.

If you want just a button connected to a macro, then instead of using the Control Toolbox, use the Forms toolbar which you can draw on the Pivot Chart.