Pivot Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
Using VBA to create charts 1
Unable to Group in Pivot Table 1
create a pivot table and chart from a named range 1
Macro to refresh pivot chart - URGENT PLEASE !!!! T_T 3
Link Drop Down list with Pivot Table 3
Pivot Chart Problem when Refreshing 1

Back
Top