Excel scatter plot

[Sam]

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

 

[Jon Peltier]

Sam -

It isn't completely automatic, but there are a couple free addins you
can download that do this for you:

Rob Bovey's Chart Labeler (http://appspro.com)
John Walkenbach's Chart Tools (http://j-walk.com)

- Jon