如何在 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
如果不可能的话,您能否建议一种将数据快速转入类别列的方法?