View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 1
Default 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