如何在Excel中使用两个系列的序数/名义数据创建折线图？

debugcn 发表于 Dev

我的

我在Excel中有这两列。

Result  Speed
------  ----
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
MEDIUM  HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  LOW
MEDIUM  LOW
MEDIUM  LOW
LOW LOW
LOW LOW
LOW LOW
LOW LOW
LOW LOW
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
MEDIUM  HIGH
HIGH    HIGH
HIGH    HIGH
MEDIUM  HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
HIGH    HIGH
MEDIUM  HIGH
MEDIUM  HIGH
MEDIUM  HIGH
MEDIUM  HIGH
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  LOW
MEDIUM  HIGH
MEDIUM  HIGH
MEDIUM  HIGH
MEDIUM  HIGH
MEDIUM  HIGH
MEDIUM  HIGH
MEDIUM  HIGH
MEDIUM  HIGH
LOW HIGH
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  LOW
LOW LOW
LOW LOW
MEDIUM  LOW
MEDIUM  LOW
LOW LOW
LOW LOW
MEDIUM  LOW
MEDIUM  LOW
MEDIUM  LOW
MEDIUM  LOW
MEDIUM  LOW
MEDIUM  LOW
MEDIUM  LOW
MEDIUM  LOW
MEDIUM  LOW
MEDIUM  LOW
MEDIUM  MEDIUM
LOW MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  LOW
MEDIUM  LOW
LOW LOW
MEDIUM  LOW
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
LOW MEDIUM
LOW MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
MEDIUM  MEDIUM
LOW MEDIUM
MEDIUM  LOW
LOW LOW
MEDIUM  LOW
LOW LOW
LOW LOW
MEDIUM  LOW

如何创建包含两条线的折线图来表示此数据？当我选择数据并尝试添加折线图时，什么也没有显示。

内维尔

那是因为您没有任何要绘制的图表。“高”，“中”和“低”不是值，因此Excel对其毫无意义。您也可以尝试在一条线上绘制汽车型号列表。您可以将“高”，“中”和“低”转换为数字，以便Excel可以使用以下公式将其绘制成图表：=IF(A1="High", 3, IF(A1="Medium", 2, IF(A1="Low", 1, "")))假设第1行的数据在单元格A1中开始。然后突出显示两列数字并插入新的折线图。

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。