Hi,

I've been looking some methods to drill down on a Pivot Chart to the Raw Data for that particular Chart metric which produces the raw data for that metric.

While this is useful, I'd like to display a Chart from that data instead as the Users prefer Charts.

What I'd like to do is use VBA to have the result of the Click on the Chart metric create a new chart of a defined type instead of the raw data.

I haven't yet found anything that already exists for this going from the original chart to drill down more than one level to a chart.

The user will want to view the original chart, select a part of a report (such as a piece of a stacked Column chart) and have that data appear as another chart rather than raw data.

Does anyone have an idea of how this can be coded?

Thanks for any suggests.