Regarding click event of charts
I am attaching a file which contains two sheets named as metadata and report.
I have made two charts on it , now when I select any region on graph1 then customers related to that particular region must be shown in graph2.
I want to use region graph for filtration process.
| Attachment | Size |
|---|---|
| issue.xls | 47 KB |
Reply
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.
Click event from graph
Well i did the same but , actually i want to make it from graphs click event.
So if you can , then please do it from graphs.
Regards
Shivam
Answer in a blog post
Hello, Shivam,
I post my answer in a blog post where I can attach files. I hope is that what you need.
excelexperts.com/reply-forum-and-blog-topics-regarding-click-event-charts
Best regards.
RE: Regarding click event of charts
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.