图表持续时间 [英] Charting duration of time

问题描述

我从这篇文章之前的阅读中确定一个甘特图是我需要创建的，但是我不知道这是否是正确的路线。

I'm fairly certain from the reading I did prior to this post that a Gantt chart is what I will need to create, however I don't know if that is the correct route or not.

需要在Excel图表上将开始和结束时间的数据绘制为一个单位，Y轴上的日期和X轴上的小时数。

Need to plot data of start and end times as one unit on an Excel chart, with date on the Y-axis and hour of day on the X axis.

开始和结束时间的格式是将数字添加到组合中的Excel数字。

The format of the start and end times are Excel numbers which is adding another curveball into the mix.

推荐答案

p>如果下面的图表是您需要的类型：

If the chart below is of the type you require:

那么我建议选择一个Stacked Bar格式。每个日期有两个数据集，但关键是格式化为不可见的。

then I'd suggest choosing a Stacked Bar format. There are two data sets for each date but the 'key' is that one has been formatted to be invisible.

图表是我相信在Excel 2007（我的版本）和更高版本之间发生了很大变化的事情，所以我希望与时并进可能会更容易。

Charting is something that I believe changed quite a lot between Excel 2007 (my version) and later versions so I hope struggling with times may be easier for you.

这篇关于图表持续时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！