How to execute a macro when data in a pivotchart changes?

  • Thread starter Thread starter TNandSEC
  • Start date Start date
T

TNandSEC

Can someone tell me how to link a macro to a pivotchart so that once the
pivotchart has been updated (by the user selecting a single item from a
drop-down-list), the macro will be executed?

Thanks
 
Grüezi TNandSEC

TNandSEC schrieb am 04.06.2004
Can someone tell me how to link a macro to a pivotchart so that once the
pivotchart has been updated (by the user selecting a single item from a
drop-down-list), the macro will be executed?
Click to expand...

How about the Calculate-Event of the worksheet that holds the piovt-table?

--
Regards

Thomas Ramel
- MVP for Microsoft-Excel -

[Win XP Pro SP-1 / xl2000 SP-3]
 
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

Refresh PivotChart subform 3
Filter pivotchart in report 1
auto updating a pivotchart? 11
Changing a PivotChart Removes Series Formatting 3
Macro to format all pivotcharts in a workbook 6
PivotChart in form display issue 6
Excel 2010: How to display PivotChart Report Filter Lables on the graph 2
PivotCharts and recalculating workbooks 1

Back
Top