Pivot Tables

J

JAmes L

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
 
D

Debra Dalgleish

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.
 
Top