| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables
Hello
I have a pivot chart. I would like to run a macro when ever the user selects a data from the drop down list in the page field. Is this possible on a pivot chart Thanks in advance James |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Tables
You can use the Chart_Calculate event to run the code.
Right-click the chart sheet tab, and choose View Code From the dropdown list at the top left of the code module, choose Chart From the dropdown list at the top right, choose Calculate Type your macro name where the cursor is flashing. JAmes L wrote: Hello, I have a pivot chart. I would like to run a macro when ever the user selects a data from the drop down list in the page field. Is this possible on a pivot chart? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
| Pivot tables-controlling user interaction with pivot tables | Excel Programming | |||
Linear Mode
