Excel:如何在Excel中创建甘特图 [英] Excel: How to create a Gantt Chart in Excel

问题描述

给出以下数据集:

 Request    starttime   Duration (ms)
 1  00.000  222
 2  00.005  257
 3  00.001  270
 4  00.003  299
 5  00.292  198
 6  00.327  199
 7  00.318  319
 8  00.333  451
 9  00.511  323

我需要绘制一个重叠的条形图，类似于该重叠的条形图(来自Google):

I need to draw an overlapping bar graph, something akin to this overlapping bar graph (from google):

但是，当我尝试在mac excel中绘制条形图时，excel会在y轴上重载请求计数和开始时间，而不是将开始时间和持续时间都应用于x轴.

However, when I try to draw the bar chart in mac excel, excel overloads the y-axis with request count and start time, rather than making start time and duration as both applied to the x-axis.

简而言之，y轴是请求号，x轴是开始时间和持续时间.excel中有没有一种方法可以将条形图移动到数据集中列出的开始时间?

In short, the y-axis is the request number and the x-axis the both the start time and duration. Is there a way in excel to shift the bars to the starting time listed in the dataset?

解决方案:在学习了如何在excel中绘制甘特图之后，结果图看起来很棒.

SOLUTION: After learning how to draw Gantt Chart in excel, the resulting chart looks great.

推荐答案

在 https:中找到了答案://www.officetimeline.com/gantt-chart-excel .谢谢大家.

这篇关于Excel:如何在Excel中创建甘特图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！