Excel制作甘式图
甘式图是什么
甘式图是以美国企业管理学家甘特名字命名,用来衡量实际与预期生产记录之间关系的图表,也称为甘特图。甘式图是一种线条图,横轴表示时间,纵轴表示需要执行的活动和任务,可以通过甘特图的线条,直观看出各个活动所需要的时间,从而可以对项目进行决策。
Gant charts are charts, also known as Gant charts, that measure the relationship between actual and expected production records, named after Gant, an American business manager. Gant chart is a line chart, the horizontal axis represents the time, the vertical axis represents the activities and tasks to be performed, through the line of gantt chart, you can visualize the time required for each activity, so that you can make decisions about the project.
Excel绘制甘式图
选中日期一列并更改为常规,日期格式会变成为常规数字。
2.选中所有数据,点击插入,在条形图中选择如图所示的条形图模板。
3.选择纵坐标轴,在坐标轴选项中勾选逆序类型。
4.选择蓝色条形图,在填充选项中勾选无填充。
5.选择横坐标轴,在坐标轴选项中边界一栏中,最小值输入最小开始时间(如图中44440),最大值输入最大开始时间并加上其所需天数。
6.修改开始时间格式,改为日期格式。
7.最终,得到了甘式图。
1. Select the date column and change it to General, and the date format becomes a regular number.
2. Select all the data, click Insert, and select the bar template as shown in the bar chart.
3. Select the vertical axis and check the reverse order type in the axes option.
4. Select the blue bar chart and check No Fill in the Fill option.
5. Select the horizontal axis, in the boundary column of the axes option, the minimum value enters the minimum start time (figure 44440), the maximum value enters the maximum start time and adds the required number of days.
6. Modify the start time format to the date format.
7. Finally, we get the Gan-style diagram.
文字|李恒宇
排版|李恒宇
审核|李小雪
参考资料:百度百科;翻译:谷歌翻译;图片:自己制作
本文由LearningYard新学苑原创,部分图片文字来自网络,如有侵权请联系。