Command Button on Pivot Chart
 

Hi all,

Alright, I've got a bit of an issue that I'm hoping someone can help me
with. I've created a Pivot Table (with Pivot Chart). The Pivot Chart is
located on it's own worksheet, called 'Chart'. I use the Pivot to display
two views of the same data. A total count and a percentage of the count.
I've got code written to have the pivot table switch back and forth between
the two types of displays.

Everything works great. Except...

I only have the code in a macro, and I want it to be accomplished with a
button on the actual chart. I'd like to remove all macros, if possible.

Now, if I create a Pivot Chart 'on' a worksheet, I can then add a command
button and I have no problems. But when the Pivot Chart 'is' the worksheet,
it won't let me add the command button.

This is mostly an issue of aesthetics. But I'd like to know if it's even
possible to add the button to the pivot chart and have it float over the
chart, or something similar.

Any help is appreciated.

Thanks,
Jay

Command Button on Pivot Chart
 

Hi Jay,

I only have the code in a macro, and I want it to be accomplished with a
button on the actual chart. I'd like to remove all macros, if possible.

This is mostly an issue of aesthetics. But I'd like to know if it's even
possible to add the button to the pivot chart and have it float over the
chart, or something similar.

You can add a button from the Forms menu (or a shape from the Drawings
toolbar) and assign a macro to it. But, you still need a macro!

Regards,
Peter T