Make click on Excel chart and automatically a new WorkBook is open with the chart's pivot table
Posted on 2014-01-23
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.