☰

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

tag-icon • tag-icon microsoft-excel charts
如何在 Excel 中使用两系列序数/名义数据创建折线图？

我在 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

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

答案1

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

相关内容