Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button in Pivot Tabls | Excel Discussion (Misc queries) | |||
add button on pivot chart | Charts and Charting in Excel | |||
Q: Hiding a field button on a pivot chart | Excel Discussion (Misc queries) | |||
command button in pivot table | Excel Programming | |||
Create event triggered by Pivot Chart field button | Excel Programming |