如何按名称标记散点图？ [英] How to label scatterplot points by name?

问题描述

我试图找出如何让标签显示在Google表格，Excel或数字中。

我看到的信息如下所示

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

然后我希望我的最终图看起来像这样。

  4 | （c）
 3 | 
 2 | （b）
 1 | （a）
 | __ __ __ __ 
 0 1 2 3 4 
  

为什么我不能用名称标记每个点？我只能标注值，例如（c）会显示 4

是唯一的解决方案D3吗？

解决方案

认为这是可能的，直到我去检查。在以前的Excel版本中，我无法做到这一点。我正在使用Excel 2013.

这就是你想要在散点图中做的事情：

1. 右键点击数据点

选择格式化数据标签（注意您可能需要添加数据标签
$ b
2. 在来自单元格的值中放置一个复选标记


3. 单击选择范围并选择范围您需要的标签

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?

解决方案

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

这篇关于如何按名称标记散点图？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！