精确的过程事件时间线图（例如在Excel中） [英] Precise process event timeline diagrams (e.g. in Excel)

问题描述

我需要准备这样的图表：

我认为这是非常直观的如何读取这个图，这就是为什么我想为我的项目创建一些。

我很困惑如何有效地创建它们;我画了上面的一个油漆只是为了快速可视化我的想法，它花了太长的imo。

我有具有事件时间的精确数据（例如正在加载过程1中开始，加载在进程1中结束，算法在进程2中开始等）例如

  1：
 00.0  -  40.0  - 正在加载
 40.0  -  45.0  - 准备和启动过程2 
 45.0  -  50.0  - 准备和启动过程3 
 50.0  -  90.0  -  Sleep 
 90.0  -  95.0  - 加入过程2 
 ... 
 
过程2：
 45.0  -  90.0  - 算法执行
 ... 
  
 
 
 
 如何生成此类时间线图？ 
 
 
 
我使用MS Windows 7并安装了Office 2010，但我愿意使用任何可以完成这项工作的任何东西。
解决方案
基本上，使用堆叠条形图：
 
 
 
  
 
 
 
详细解释所有步骤将是一场噩梦，但大致上，数据大致如下所示 A1：H4 。格式化数据系列白色，以便混合到背景中。添加数据标签并根据需要更改其文本（合并1等）。 
 
 
 
我欺骗并绘制线条（例如在加载中）并将其格式化为白色，但额外的连接器为1ms应该线）。使用系列选项调整钢筋的间距和高度。 
 
 
 
编辑：
 
 
 
列标签与@Jon Peltier匹配程度更高或更低，但不重要这里。它们可以被视为仅仅是增量。基于注释提供的更具体的值：
 
 
 
  
 
I need to prepare such diagrams:



I think it's quite intuitive how to read this diagram and this is why I want to create a few of them for my project.

I am quite confused how to create them efficiently; I've painted the one above in Paint just to quickly visualize my idea and it took too long imo. Moreover the time axis is not accurate.

I have precise data with event times (eg. loading start in process 1, loading end in process 1, algorithm start in process 2 etc.) e.g.
Process 1:
00.0 - 40.0 - Loading
40.0 - 45.0 - Preparing and launching process 2
45.0 - 50.0 - Preparing and launching process 3
50.0 - 90.0 - Sleep
90.0 - 95.0 - Joining process 2
...

Process 2:
45.0 - 90.0 - Algorithm execution
...
How to generate such timeline diagrams? 

I am using MS Windows 7 and have Office 2010 installed, but am willing to use anything that gets the job done..
解决方案
Basically, use a stacked bar chart:  



To explain all the steps in detail would be a nightmare but in outline, the data is roughly as shown A1:H4.  Format the data series white where required to blend into the background. Add data labels and change their text as required ('merge 1' etc). 

I cheated and drew lines (eg within 'Loading') and formatted them white but extra 'connectors' of 1 ms should serve (and would then scale, unlike the drawn lines). Adjust the separation and height of the bars with Series Options.  

Edit:  

The column labels more-or-less match up with @Jon Peltier but are not important here. They can be taken as merely increments in order. Based on the more specific values provided by comment:  

  

                        
这篇关于精确的过程事件时间线图（例如在Excel中）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！