Scattergraph labels identifying single point | Excel forum

Hi Areti,

Yes it can be done using VBA.

It is not just a bit of code, and the code will not help you if you cannot reference your objects in the code. We are doing consultancies where we analyse the client's workbook and based on the client's wishes doing the coding. I need to know the reference to each of the points in your chart. I will need to know the exact text string you want to display, when someone double click the point. I will need to know the reference index number to your chart. I will have to set a double click event in you workbook to execute the code. I will have to make references in objects variables stored in your computers memory.

And if you change the chart by adding new students the code need to be amended.


Sorry it is outside the scope of our forum, but if you get VBA knowledge and struggle with code I can help you with questions based on your code.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector