如何在Excel中创建时间表图表？

How do I create a timeline chat which visualizes peoples activities throughout a day in one graph? On the x-axis I plan to place the time. And the y-Axis would be the different persons. First, I thought of a simple stacked bar chart. However, the problem is that Excel would combine all the same activities to one item and don't visualize it on the timeline... I also can't do it by hand as I have several 1000 entries to visualize...

如何创建一个时间线聊天,在一个图表中一整天可视化人们的活动?在x轴上我计划放置时间。而y轴将是不同的人。首先,我想到了一个简单的堆积条形图。然而,问题是Excel会将所有相同的活动组合到一个项目上,并且不会在时间轴上将其可视化...我也无法手动完成,因为我有几千个条目可视化...

I found this post on *, but there there is only one activity per entry and not mulitple times the same...

我在*上发现了这篇文章,但每个条目只有一个活动而不是多次相同...

It would be great if I could use Excel (as my data set is there). But if there is a better way (i.e. tool) I'd also appreciate new suggestions.

如果我可以使用Excel(因为我的数据集在那里)会很棒。但如果有更好的方法(即工具),我也会欣赏新的建议。

This is what I imagine the timeline to look like:

这就是我想象的时间轴:

2 个解决方案

#1

If you have data prepared in the correct way this can be easily done in Excel. Check the animation below (you can open image in a new tab to see the full resolution).

如果您以正确的方式准备了数据,则可以在Excel中轻松完成。检查下面的动画(您可以在新选项卡中打开图像以查看完整分辨率)。

#2

As I didn't find a solution that let me create a timeline in Excel, I used JavaScript and the visualization framework D3, together with a neat opensource library, d3-timeline: https://github.com/jiahuang/d3-timeline

由于我没有找到让我在Excel中创建时间轴的解决方案,我使用了JavaScript和可视化框架D3,以及一个整洁的开源库,d3-timeline:https://github.com/jiahuang/d3-timeline