Hello,

If you going to use charts together with pivot tables (as in your example file), my first suggestion, because is the easiest way, is to add REGION_NAME as Report Filter in your Graph2 and restrict graph view from there.

For example:

There is no problem to use chart click event, it's all about what is your ultimate goal. If you still want to be done with chart click event, it's Ok, I may try to make something to you.

Best regards.

Hello,

I would you suggest to check the Vishesh's blogs

excelexperts.com/Chart-Zoomer

and

excelexperts.com/Chart-Event-Double-Click-on-Chart

but as I see you already be in the first one. In that case, please would you be more specific on that what exactly you want to understand: a chart click event, get specific data and add them to a new chart or to a new pivot table... or if you want completed solution it would be better to attach your sample example file on which to be made changes. Or if there is something else, just ask...

Best regards.