View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Ramage[_3_] Dave Ramage[_3_] is offline
external usenet poster
 
Posts: 8
Default 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
.