How can I find Pivot Table Sheet for Pivot Chart?

M

MikeZz

I have a workbook with a bunch of pivot charts where the pivot tables are
hidden to make it clean.

I want to put a button on the chart that finds the correct pivot worksheet
for the selected pivot chart, unhide it, then activate that pivot sheet.

Any ideas how to determine the Pivot Table Worksheet Name?

The other logical question....
Is there a way to find and activate any charts that use the currently
selected pivot table as source data?

Thanks
MikeZz
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Change report firlds in pivot tables and charts with one selection 0
Pivot Table - charts - default ? 0
Changing pivot table ADO recordset 0
create a pivot table and chart from a named range 1
Using VBA to create charts 1

Top