custom tooltips on excel bubble chart

[mrcasasc]

Hello

Im new here and still learning a lot. I need help to understand how to customize the tooltip to show other information of my choice rather than X/Y location (as below).

is there an eazy way to do this?

thank you

 

[p45cal]

Have a look at https://www.clearlyandsimply.com/cl...ml#comment-6a00e554d9fb9988330264e2e6020e200d
and its linked-to file (I haven't looked at it but the date of the post is relatively recent). See also the rest of that thread/article.

You might also be able to do it using data labels, adding and configuring them on the fly as you mouse over various parts of the chart (you can't just hide/unhide individual data labels unfortunately).

 

[mrcasasc]

thank you for your answer, yes i found those articles too and actually i took one of the files and use to make my own bubble chart (by changing the data).

i need to learn how to do that from the beginning (new to VBA)