HI,
I know how to manipulate a PivotChart, but can't find a way to detect when user has drilled down or drilled out of the data on the chart. Currently I have this chart as the overview:
Then, if the user double clicks 'management' as an example, I get this chart:
and what I want is this:
If I could detect the drill down double click I can sort it out, I just don't know how to capture that double click (I have tried Worksheet_BeforeDoubleClick, but it doesn't capture a double click in a PivotChart).
Any ideas gratefully received.
I know how to manipulate a PivotChart, but can't find a way to detect when user has drilled down or drilled out of the data on the chart. Currently I have this chart as the overview:
Then, if the user double clicks 'management' as an example, I get this chart:
and what I want is this:
If I could detect the drill down double click I can sort it out, I just don't know how to capture that double click (I have tried Worksheet_BeforeDoubleClick, but it doesn't capture a double click in a PivotChart).
Any ideas gratefully received.