如何在Excel中创建时间线图表？ [英] How do I create a timeline chart in Excel?

问题描述

如何创建时间轴聊天，以一张图表直观地显示人们一天的活动？我计划在x轴上放置时间。 y轴将是不同的人。首先，我想到了一个简单的堆叠条形图。但是，问题是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...

我发现此帖子在Stackoverflow上，但是每个条目只有一个活动，并且没有多个相同的活动...

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

如果我可以使用Excel（因为我的数据集在那里），那就太好了。但是，如果有更好的方法（例如工具），我也将不胜感激新的建议。

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.

我想这就是时间表的样子：
< img src = https://i.stack.imgur.com/HIIx0.png alt =这是我想像的时间表>>

This is what I imagine the timeline to look like:

推荐答案

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

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中创建时间线图表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！