如何创建显示多个事件的时间线图表?例如.维基上的金属乐队成员时间线 [英] How do I create a timeline chart which shows multiple events? Eg. Metallica Band members timeline on wiki

问题描述

如何创建显示多个事件的时间线图表?例如.Metallica 乐队成员在 wiki 上的时间表?它显示了多个乐队成员及其持续时间.

How do I create a timeline chart which shows multiple events? Eg. Metallica Band members timeline on wiki ? where it shows the multiple band members and their durations.

要使用的技术:主要是 Microsoft Office.任何学习曲线不太适合做这些东西的奇异技术也应该没问题?

Technologies to be used : Microsoft Office primarily. Any exotic technology where the learning curve isn't too much to do this stuff, should also be fine?

推荐答案

堆叠条形图就足够了:

设置数据如下

Name    Start       End         Duration (End - Start)
Fred    1/01/1981   1/06/1985    1612   
Bill    1/07/1985   1/11/2000    5602  
Joe     1/01/1980   1/12/2001    8005  
Jim     1/03/1999   1/01/2000    306  

1. 将 Start 和 Duration 绘制为堆积条形图
2. 将X轴最小值设置为所需的开始日期
3. 将start范围的Fill颜色设置为no fill
4. 设置各个条的Fill以适应

1. Plot Start and Duration as a stacked bar chart
2. Set the X-Axis minimum to the desired start date
3. Set the Fill Colour of thestart range to no fill
4. Set the Fill of individual bars to suit

(在 Excel 2010 中准备的示例)

(example prepared in Excel 2010)

这篇关于如何创建显示多个事件的时间线图表?例如.维基上的金属乐队成员时间线的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！