Excel scatter plot

  • Thread starter Thread starter Sam
  • Start date Start date
S

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
 
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
 
Back
Top