Dear All,
Does anybody have a code which helps in clicking on a bubble in a bubble chart and go (event) to a specific sheet? I am talking about Embedded Charts on a worksheet.
This sheet has a named range which is linked to various formulas and creates a summary of the bubble value/Entity.
Your prompt response will be really helpful.
Regards
Sidd
Sidd06, welcome to ExcelFox.
Yes, that can be done. Where should it take you to? Do you have sheets for each bubble? Or are you referring to certain ranges within a particular sheet? Can you confirm exactly what the code should do when any bubble on the chart is clicked.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Hi,
I have one summary sheet which has a named range. On a click of the bubble the name of the bubble needs to passed to this named range.
Hope it is clear now.
Regards
Sidd
Posting Permissions
Reply With Quote
Bookmarks