Hover labels on scatterplot points

You can not edit the content of chart hover labels. The information they show is directly related to the underlying chart data, series name/Point/x/y

You can use code to capture events of the chart and display your own information via a textbox.
http://peltiertech.com/chart-events-microsoft-excel/

Thanks so much for this Andy! It was quite helpful!

Can i pick your brain one more time?

I wrote some code and its doing all i need - except I am trying to place a textbox label next to a point inside the chart. I cant seem to get right the alignment.
I am not quite understanding how ActiveSheet.Shapes.AddTextbox(1, x, y, 100, 70) works. I understand X and Y are points relative to the top left corner, but what comes out in the chart is relative to the chart I guess and not the chart sheet? Not sure if I explained this correctly. I am very new to vba but amazed at how powerful it is!

Any thoughts how I can fix this and have my code show a textbox next to the point in the series that i have the mouse over?




Here is my code for reference - and maybe its useful for someone out there

Please Login or Register  to view this content.

Thanks!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)


The x and y arguments are mouse coordinates and are on a different scaling to the chart element positional values.
Simplest thing to do is use the Arg2 value to identify the point and then use it's left/top values to position textbox.

Please Login or Register  to view this content.

I have also modified the code so the shape is added once and then hidden or made visible as required.

Please Login or Register  to view this content.

You need to remember the point that was coloured so you can reset the same point. mLastArg2 is used to store the value.

Speed72...

Hi.

It's a forum rule that you start your own thread, rather than "piggy-backing" on someone else's thread. This helps prevent massive confusion arising - which will happen if it is not clear which question is being answered. So please start your own thread and explain your own problem (make sure that, right from the start, you use a meaningful title (NOT things like "help needed" or "urgent problem"... think of the Google search terms that you would use to find the solution).

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures. So, prepare a SMALL sample sheet (10-20 rows, not thousands!!!). Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!


The yellow banner about sample worksheets, at the top of the screen tells you how to post a sheet here on the Forum.