Pop-up box for names in Scatter Chart

[Tancho]

Hi All,

I am trying to get my Scatter Chart to have a pop up box appear when I hover on the point on my Scatter Chart. I want the chart to show the name, KS1 and KS2 Pred data for each point. Is there a VBA code that will let me do this please?

For ease I have uploaded a sample file. Sheet 1 contains the data that has been plotted and the chart the final plot. The orange lines have been manually added to the chart and are to show a national data set average so can be ignored.

Also, is it possible to have the points a different shape or colour according to the gender please?

Many thanks in anticipation.

Regards

Tancho

[dflak]

I had to pull this out of the archives both from the sample workbooks (it's from an *.xls workbook - pre 2007) and from my mind.

I does not display on hover. You have to click the point. I could not find an "on hover" event.

Here is what I did:

I put some named dynamic ranges on your data on sheet 1 so you can add to this table and the chart will catch it, although an Excel Table would have been easier.

You stated that you wanted different markers for male and female - if you want different markers, make different series. I've done this in the helper columns F:I, These columns are overlaid with dynamic ranges too for the purposes of plotting.

I went to the chart and plotted the male series and the female series.

Then on the sheet containing the chart, I inserted my old code and modified it.

[Tancho]

That works perfectly! Thank you for your quick response and help.
Much appreciated.

[Andy Pope]

@dflak, you can use the mousemove event. Although using a messagebox means you have to be careful not to move over points you are not interested in.

[Tancho]

Possibly a daft question but where I have the orange lines (national averages) is there a way to get this automatically? At the moment if a plot is on the line it won't open the box as it selects the line. I know this is because I have put these in by hand but wondered if there was a way to get these so that I can still select points.

Apologies for another question but thank you in anticipation for your time again.

[Andy Pope]

Why not create another series, line with no markers, to draw though lines as part of the chart?

[dflak]

Amdy: I see a MouseMove, MouseDown and MouseUp event. I do not see a MouseOver.

Tancho. Andy's suggestion is probably the solution. However, move the new series up or down in the data so they are "under" the points you want to select.

[Andy Pope]

There is not a mouseOVER event. You would use the same code but place it in the mousemove event. Obviously the event is firing a lot more often than the mousedown.

Another option to the mousedown event is the selected event.

[ETA2505]

Hi, I have similar scatter chart with MouseUp event, however when I filter on chart (example female only) the message box does not display.
Would you please be able to help? Eva