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.
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