Areti has attended:
Excel VBA Intro Intermediate course
Excel VBA Intermediate course
Scattergraph labels identifying single point
I have a scattergraph showing 180odd students' Maths vs English grades. I've added labels and I know how to add the student name as well with the 'value from cells' option. Is it possible to double click on a point and have only that student's name/ grades appear in Excel or does this require some VBA code?
If it needs VBA would appreciate some help as that's way beyond my expertise. Many thanks
Areti
RE: Scattergraph labels identifying single point
Hi Areti,
Thank you for the forum question.
Everything is possible using VBA, but it is outside the scope of this forum to develop code for clients. We help and answer VBA question, but our clients will need to have VBA knowledge.
The VBA code you need for this is advanced VBA. You will need to understand and have experience in object oriented programming plus an understanding of VBA structure and EXcel VBA objects, methods and properties.
Sorry I cannot help you with this.
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
RE: Scattergraph labels identifying single point
Hi Jens
Am I correct in thinking this is not possible within Excel itself? I just wanted to check that I'm not missing anything before I look at writing a VBA solution if so. I understand you can't provide a bit of code.
Thanks
RE: Scattergraph labels identifying single point
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
