View original (French)

Edit tooltip on 3D point cloud in Excel 2003

Solved
ccm81 Posted messages 11033 Status Member -  
ccm81 Posted messages 11033 Status Member -
Hello

How can you modify the tooltip when hovering over a point in a scatter chart (Excel 2003)

Thanks

11 answers

Answer 1 / 11
JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
 
Good evening,

look at what MichelXld or jboisgontier are proposing: https://www.excel-downloads.com/threads/nuages-de-points-label-infobulles.108776/

Kind regards
1
Answer 2 / 11
JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
 
a proposal: https://www.cjoint.com/c/DLuoNXbztJW

it needs to be refined because it does not differentiate a point from an axis graduation.

See you soon
1
Answer 3 / 11
JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
 
First, you need to add a rectangle to each chart, then restore the rectangle masking if the mouseover is not on a point, and restore the display of this "rectangle 1" with the content of textbox1.text created by your macro.

I have modified the rectangle positioning to be more pleasant when you move the mouse.

https://www.cjoint.com/c/DLupZWNFVjG

cordially
1
Answer 4 / 11
ccm81 Posted messages 11033 Status Member 2 434
 
I suspect it must be twisted, but isn’t there a way to achieve it via macro(s)?
0
Answer 5 / 11
Raymond PENTIER Posted messages 58208 Registration date   Status Contributor Last intervention   17 478
 
Maybe! We do so many things with a macro ...

--
It's good, retirement! Especially in the Antilles ... :-)
Raymond (INSA, AFPA, CF/R)
0
Answer 6 / 11
ccm81 Posted messages 11033 Status Member 2 434
 
Thank you,

I managed to retrieve the point number, that's something already, but not able to modify the tooltip attached to the point

Regards
0
JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
 
hello ccm81,

do you have a file with whatever you want?
0
Answer 7 / 11
ccm81 Posted messages 11033 Status Member 2 434
 
Here is what I managed to obtain
https://www.cjoint.com/?3LuowHy5Yxi
0
Answer 8 / 11
ccm81 Posted messages 11033 Status Member 2 434
 
Thank you,

I added the test on the ElementID value (3 for a point) and transformed AfficheInfo into a function (it looks cleaner), it works well (and it’s more rewarding than double-click) to fill the textbox, but it doesn’t affect the tooltip of the points 

Private Sub Graph_MouseMove(ByVal Button As Long, ByVal Shift As Long, _
 ByVal x As Long, ByVal y As Long)
 Dim ElementID As Long
 Dim Arg1 As Long, Arg2 As Long
 On Error Resume Next
 ActiveChart.GetChartElement x, y, ElementID, Arg1, Arg2
 If ElementID <> 3 Or Arg2 = 0 Then
 ActiveSheet.TextBox1.Text = ""
 Else
 ActiveSheet.TextBox1.Text = AfficheInfos(Arg2)
 End If
End Sub

Regards
0
JvDo Posted messages 1924 Registration date   Status Member Last intervention   859
 
well normal since I removed the tooltip to redirect to the textbox!!

if you want both, you need to put the tooltip part back into the class module

best regards
0
Answer 9 / 11
ccm81 Posted messages 11033 Status Member 2 434
 
OK, and what’s the trick? (I’m discovering Class Modules so you’ll understand I’m struggling, shut up)
0
Answer 10 / 11
ccm81 Posted messages 11033 Status Member 2 434
 
Beautiful trick to bypass the problem; we just need to work on the rectangle’s coordinates so that it doesn’t disappear when approaching the edges of the graph, I think I can handle that myself.
Thank you again
I’ll wait a bit before marking it as resolved

Have a good rest of the day

Best regards
0
Answer 11 / 11
Raymond PENTIER Posted messages 58208 Registration date   Status Contributor Last intervention   17 478
 
It’s impossible.

--
It’s good, retirement! Especially in the Antilles ... :-)
Raymond (INSA, AFPA, CF/R)
-3