200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi Variatus,
I have added some more charts on my dashboard and the charts are from different sheets but same workbook.
1. Could you please modify the previous code you sent me.
Attached file for your reference.
I have more queries as per below:
2. Also advise while clicking on the chart it brings be to the a specific cells as well.
3. My Graphs willbe dynamic.. In case graphs are updated will there be any issue.
Thanking you in advance for your top support.
Your wishlist can't be fulfilled with your current setup. You need to transfer your charts to a Chart sheet. Find instructions here.
I have read a lot about the subject while doing my reasearch on this answer. Many, if not most, people recommend a "Dashboard" to be created with embedded charts, avoiding a Chart sheet. Following that advice has cost me a lot of time. Pellier (the author of the article at the above link) is a renown VBA specialist at Microsoft and beyond. He takes a completely different approach by saying, in effect, "put charts on a Chart sheet".
This seems to be because the Chart sheet has some functionality a normal worksheet doesn't have. First among these are Chart events which I painstakingly installed in your worksheet in my last answer. The point where I got stuck now is to define a group of charts, any one of which might have been clicked. It might still be possible with your current setup but when you use a Chart sheet it's standard fare.
