Display information upon mouseOver on a scatter chart

[AYData]

Have a workbook setup to display information on Players within a game, so player name, location on map (x, y coords), player rank & note about the player.
Player coords and their name as well as the note on them are concatenated into one field.

Cell A1 has PlayerName ie Striker
Cell B1 has X coords ie 76
Cell C1 has Y coords ie 202
Cell D1 has player Level
Cell E1 note on player
Cell F1 has Friend or Foe information
Cell G1 has concatenated information of the previous cells.

Using A1 as series name
Series X values are taken from $B$2:$B$300
Series Y values are taken from $C$2:$C$300

Cell G has concatenated information from cells B, C, A, D, E & F ie (76, 202) Striker 36 Leader of clan

Want to use this cell G information as a mouseOver label for each point on scatter chart.

Chart is displaying information for series correctly, but want to add this feature for the users to see who is at which point on chart.

[AYData]

Have worked out how to display the information I need on chart, however it is present for all data points on chart and is extremely messy due to the number on points being displayed. Need it to be only when the user places their mouse over a specific point and have it display that information.

[AYData]

messyInfo.jpg

As can be seen by the snapshot, it get's real messy. So my thinking is that having the information show only when a user moves their mouse over the data point would be better.

[JosephP]

a sample workbook will likely get more help than a picture ;-)

[AYData]

This is the file I am working on, information in it is not of a critical nature so have no issue uploading the actual file.

[JosephP]

right-click the sheet tab, choose 'view code' and paste this code

Please Login or Register  to view this content.

also add this to the ThisWorkbook module of the workbook

Please Login or Register  to view this content.

note: you will need to activate the chart by clicking on it for the code to work

[AYData]

Thank you Joseph, but it appears to still not be working. followed your steps and added the VB code but with no result.

[JosephP]

did you reopen the file to trigger the hookChart routine?

[AYData]

Got it working now thank you.
It somehow added twice the following lines
Public Sub hookChart()
Set cht = Me.ChartObjects(1).Chart
End Sub

Private Sub Worksheet_Activate()
hookChart
End Sub

That code showed up twice when I read through the coding.

Cudos to you for that, once more thank you for the help.

[JosephP]

you're welcome :-)

please don't forget to mark the thread solved (click the 'thread tools' link at the top, then 'mark solved')