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

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