Drilldown into Pivot Charts (Event Class)
Captures a Shift+Click on a pivot chart, enabling drill down into the underlying pivot table. It has three (3) components, one a class module, one contains code for ThisWorkbook, and one is a regular module that sets and resets the event to the current chart. I've trimmed out anything specific to the client, but you still to debug and customize it to fit your needs.
Right-click to Save Target As: Excel_PivotChart_Drilldown.zip