Make click on Excel chart and automatically a new WorkBook is open with the chart's pivot table

I have a excel file in which I have 5 pivots tables and its charts.

Pivot tables are in sheet2 and charts are in sheet1.

What I want to do is to make click on one chart and then automatically the chart's pivot table is shown in a new workbook. A new workbook with only one pivot table.
acunaaraAsked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
Is this what your looking for ??

I created 2 other charts but not pivot
I removed the link you had on the chart to point to a macro and instead created a button htat hold a code that will call a macro in the module.

Please test it and check the result. It will only work on Pivot as this is what you requested.

Let me know your comments.
gowflow
Pivot-and-Chart-V01.xlsm
0
 
gowflowCommented:
Could you post this workbook that have the charts linked to the pivot ?
gowflow
0
 
acunaaraAuthor Commented:
The info is confidential but I made an example of what I want to do.

Please see attach file
Pivot-and-Chart.xlsm
0
 
acunaaraAuthor Commented:
Thank you dude

This is very useful!!
0
 
acunaaraAuthor Commented:
Just in case:

The TableRange1 property doesn't include page fields. So, I just changed it to TableRange2.

http://msdn.microsoft.com/en-us/library/office/aa215737(v=office.11).aspx

Kind regards and many thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.