How to label scatterplot points by name?

loonyuni picture loonyuni · Apr 14, 2016 · Viewed 146.6k times · Source

I am trying to figure out how to get labels to show on either Google sheets, Excel, or Numbers.

I have information that looks like this

name|x_val|y_val
----------------
a   |    1|    1
b   |    2|    4
c   |    1|    2

Then I would want my final graph to look like this.

4|      .(c)
3|
2|  .(b) 
1|  .(a)
 |__ __ __ __
0   1  2  3  4

Like why can't I label each of these points with its name? I can only seem to label the value, e.g, (c) would show 4

Is the only solution D3?

Answer

Forward Ed picture Forward Ed · Apr 14, 2016

Well I did not think this was possible until I went and checked. In some previous version of Excel I could not do this. I am currently using Excel 2013.

This is what you want to do in a scatter plot:

  1. right click on your data point

  2. select "Format Data Labels" (note you may have to add data labels first)

  3. put a check mark in "Values from Cells"
  4. click on "select range" and select your range of labels you want on the points

Example Graph

UPDATE: Colouring Individual Labels

In order to colour the labels individually use the following steps:

  1. select a label. When you first select, all labels for the series should get a box around them like the graph above.
  2. Select the individual label you are interested in editing. Only the label you have selected should have a box around it like the graph below.
  3. On the right hand side, as shown below, Select "TEXT OPTIONS".
  4. Expand the "TEXT FILL" category if required.
  5. Second from the bottom of the category list is "COLOR", select the colour you want from the pallet.

If you have the entire series selected instead of the individual label, text formatting changes should apply to all labels instead of just one.

Colouring