Scatter Chart with Dots displaying Spreadsheet Contents

[WRB403]

I have a scatter chart with dots that represents information in a spreadsheet. I would like to place my cursor on a particular dot and it would show the contents of a particular cell in the spreadsheet. In the example, I would like to place my cursor on a dot in the chart and the name of the bond (in column C) would appear. When I move my cursor away from the dot, the name would disappear. I do not want to add the names as permanent labels because the chart would become very cluttered with many dots.

Can this be done?

Thank you

 

[Peter Bartholomew]

Yes, it can be done on versions of Excel that support VBA. You would need to handle events that relate to mouse movements. This is not a trivial exercise. For a start you will need to define a Class for Chart Objects with Events.
Using events with embedded charts | Microsoft Learn

 

[p45cal]

You could do it by plotting each row as a separate series, then you get this when you hover the mouse over a point:

(You could automate the creation of many series with a little vba code)

Other than that there is a 2 decade old addin that might still work at http://www.tushar-mehta.com/excel/software/chart_hover_label/

 

[AlanSidman]

crossposted at: https://www.mrexcel.com/board/threa...spreadsheet-information.1218789/#post-5958924
and https://www.excelforum.com/excel-ch...-dots-displaying-spreadsheet-information.html

 

[vletm]

WRB403
Please reread Forum Rules, which are for You too:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

 

[WRB403]

You could do it by plotting each row as a separate series, then you get this when you hover the mouse over a point:
View attachment 81234
(You could automate the creation of many series with a little vba code)

Other than that there is a 2 decade old addin that might still work at http://www.tushar-mehta.com/excel/software/chart_hover_label/

 

[WRB403]

That appears to be a possible solution. I am far from an expert in Excel so I would need help with a VBA code. Can you offer anything?
Thank you

 

[p45cal]

There's a macro blah in the attached which is called when you click Button 1 at cell Q2 in the attached.
It works on what you select on the sheet before you click the button, so select the rows you want plotted from the outlined range K3:M7 and click the button. You don't have to select all the rows and you can select non-contiguous rows.

 

[p45cal]

So nice when people say thank you.

 

[Musupothers]

I have a scatter chart that has dots on it to show data from a spreadsheet. I want to position my cursor on a specific dot.

 

[Luke M]

I have a scatter chart that has dots on it to show data from a spreadsheet. I want to position my cursor on a specific dot.

Please do not hijack other user's threads. If you have a question, you can start a new thread.