Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mixing scatter plot with a category plot | Charts and Charting in Excel | |||
scatter plot in new version of Excel | Charts and Charting in Excel | |||
Excel Scatter Plot | Charts and Charting in Excel | |||
3D Scatter plot in Excel | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel |