![如何在 Excel 中构建绘图数据而不将类别分成多列?](https://linux22.com/image/1478877/%E5%A6%82%E4%BD%95%E5%9C%A8%20Excel%20%E4%B8%AD%E6%9E%84%E5%BB%BA%E7%BB%98%E5%9B%BE%E6%95%B0%E6%8D%AE%E8%80%8C%E4%B8%8D%E5%B0%86%E7%B1%BB%E5%88%AB%E5%88%86%E6%88%90%E5%A4%9A%E5%88%97%EF%BC%9F.png)
如何在 Excel 中绘制以下数据,其中每个类别的颜色不同?
category | datetime | score
--------------------------------------
foo | 2016-01-01 00:00:00 | 1
bar | 2016-01-01 00:00:01 | 2
bar | 2016-01-01 00:00:02 | 3
foo | 2016-01-01 00:00:02 | 2
baz | 2016-01-01 00:00:02 | 5
foo | 2016-01-01 00:00:03 | 5
baz | 2016-01-01 00:00:03 | 8
qux | 2016-01-01 00:00:03 | 1
foo | 2016-01-01 00:00:04 | 3
bar | 2016-01-01 00:00:04 | 3
baz | 2016-01-01 00:00:04 | 6
qux | 2016-01-01 00:00:04 | 1
如果不先将上述内容转换为类似这样的内容,是否可行?
datetime | foo | bar | baz | qux
-------------------------------------------
2016-01-01 00:00:00 | 1 | | |
2016-01-01 00:00:01 | | 2 | |
2016-01-01 00:00:02 | 2 | 3 | 5 |
2016-01-01 00:00:03 | 5 | | 8 | 1
2016-01-01 00:00:04 | 3 | 3 | 6 | 1
如果不可能的话,您能否建议一种将数据快速转入类别列的方法?