| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I find Pivot Table Sheet for Pivot Chart?
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
| Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
| Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
| How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. | Excel Discussion (Misc queries) | |||
| Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming | |||
Linear Mode
