I made a Scattered Chart for my Data in MS Excel.


ID, Valence, Arousal
1, -1.15, 0.3
2, -2.25, -1.99
3, -3.15, -2.69

My Graph looks perfect, just one requirement, the points on the chart should point towards the ID, (i.e. when I click on the point, it should say, ID =1 or something similar, rather than values of Valence and Arousal).

I have over 1000 similar data points, is there any way to achieve this?


You can use Data Labels with the option "Value from Cells", as the link in the comment to your question suggests.

However, this feature is buggy and can produce unwanted results if the underlying data changes.

Rob Bovey's free add-in called "XY Chart Labeler" has been doing a great job for years and works with all desktop based versions of Excel. Download from the original web site http://www.appspro.com/Utilities/ChartLabeler.htm

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.