Name points on scatter plot
Solved
flo644
-
Xelloss -
Xelloss -
Hello,
I would like to know how I can label the points in my scatter plot made from x; y coordinates
for example:
name: a, b, c, d.
x: 6, 8, 15, 28.
y: 5, 26, 18, 36.
etc ...
( I just want to place the letter ( a,b,...) on the corresponding point.
I know there is a way to do this without coding but I can't remember how to do it...
Thank you for enlightening me on this :)
I would like to know how I can label the points in my scatter plot made from x; y coordinates
for example:
name: a, b, c, d.
x: 6, 8, 15, 28.
y: 5, 26, 18, 36.
etc ...
( I just want to place the letter ( a,b,...) on the corresponding point.
I know there is a way to do this without coding but I can't remember how to do it...
Thank you for enlightening me on this :)
Configuration: Windows XP Safari 532.5
8 réponses
Hello.
"I just want to put the letter (a, b, ...) on the point that corresponds to it.
I know there's a way to do this without coding" ► FALSE!
The type of chart you chose does not rely on a 3-column table (name, x, and y) like other types, but only on 2 columns.
The proof is that if you select all 3 columns, you will get 2 curves, one for x and another for y.
To get your x.y scatter plot, you must only select the columns containing the values of x and y.
The column with the names does not belong to your data range, and you cannot use it as labels.
You need to do the labeling work one label at a time:
* Right-click on the curve/Add Data Labels
* Click twice on a label to select it alone; then you can access the formula bar, where you type the equal sign = and click on the name (in the Name column of the table); this name will replace the y value in the label.
* Repeat for each pair of data (hoping there aren’t dozens of them...).
Good luck.
--
Retirement is great! Especially in the Antilles... :-)
☻ Raymond ♂
"I just want to put the letter (a, b, ...) on the point that corresponds to it.
I know there's a way to do this without coding" ► FALSE!
The type of chart you chose does not rely on a 3-column table (name, x, and y) like other types, but only on 2 columns.
The proof is that if you select all 3 columns, you will get 2 curves, one for x and another for y.
To get your x.y scatter plot, you must only select the columns containing the values of x and y.
The column with the names does not belong to your data range, and you cannot use it as labels.
You need to do the labeling work one label at a time:
* Right-click on the curve/Add Data Labels
* Click twice on a label to select it alone; then you can access the formula bar, where you type the equal sign = and click on the name (in the Name column of the table); this name will replace the y value in the label.
* Repeat for each pair of data (hoping there aren’t dozens of them...).
Good luck.
--
Retirement is great! Especially in the Antilles... :-)
☻ Raymond ♂