Click On Bubble In Bubble Chart To Take User To A Sheet Or Range

[Sidd06]

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

[Excel Fox]

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.

[Sidd06]

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