Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mixing scatter plot with a category plot Janet A. Thompson Charts and Charting in Excel 2 April 1st 10 06:53 PM
scatter plot in new version of Excel Julie Heldt Charts and Charting in Excel 2 January 16th 08 01:40 PM
Excel Scatter Plot adamuk Charts and Charting in Excel 2 March 27th 06 01:48 PM
3D Scatter plot in Excel Havard Charts and Charting in Excel 1 June 8th 05 02:15 PM
Can I copy x-y scatter plot data direct from one plot to another? Chris Charts and Charting in Excel 2 June 3rd 05 01:20 PM


All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"