Excel scatter plot
 

Suppose I have a sheet with three columns and the value is like the
following:

ID X Y
===========
A 1 1
B 2 3
C 5 4

I can easily make a scatter plot of X vs Y, but I am struggling to
find a way to automatically mark each spot with the corresponding ID.
Something like the below:


6 |
|
4 | .C
| .B
2 |
| .A
0 |-------------
2 4 6

Does anyone of you know how to do this automatically (by which I mean
I do not need to manually do it with something like text box etc.)?
Thank you very much!

Sam

Excel scatter plot
 

There is no way to do this as part of the XY chart
process, but the next best thing is to use Rob Bovey's
very useful XY chart labeler tool:
www.appspro.com

Cheers,
Dave
-----Original Message-----
Suppose I have a sheet with three columns and the value
is like the
following:

ID X Y
===========
A 1 1
B 2 3
C 5 4

I can easily make a scatter plot of X vs Y, but I am
struggling to
find a way to automatically mark each spot with the
corresponding ID.
Something like the below:


6 |
|
4 | .C
| .B
2 |
| .A
0 |-------------
2 4 6

Does anyone of you know how to do this automatically (by
which I mean
I do not need to manually do it with something like text
box etc.)?
Thank you very much!

Sam
.