如果您是金融专业人士或金融学生,您可能听说过甘特图(Gantt Chart)。它是一种水平条形图,最常用于项目管理和计划。它在时间线上显示了整个项目。这是它最显着的好处。甘特图(Gantt Chart)可帮助您分析以下数据:
- 每个任务的开始和结束,
- 每个任务的总持续时间,
- 项目截止日期,
- 项目从头到尾的完整时间表等等。
在本文中,我们将讨论在Google 表格中创建(Google Sheets)甘特图(Gantt Chart)的步骤。
如何在Google表格中制作甘特图(Gantt Chart)
1]首先(First),您必须在Google 表格(Google Sheets)中创建一个新项目。在三列中键入您的项目数据。在这里,我们将数据分类为Project Name、Start Date和End Date。您可以根据自己的选择输入数据。现在,通过输入项目名称以及开始和结束日期来完成您的表格。
2] 现在,复制第一列并将其粘贴到您创建的表格下方,中间留一行。将新表的第二列命名为Starting Day,将第三列命名为Duration of the Project。请参阅下面的屏幕截图。
3]您必须在第二个表的第二列中应用一个公式。为此,请选择第二个表中项目 1旁边的单元格。(Project 1)在我们的例子中,它是单元格编号B14。在那里写下以下公式,然后按Enter:
=INT(B2)-INT($B$2)
请注意,在上面的公式中,我们写了 B2,因为项目 1(Project 1)的开始日期位于 B2 单元格中。您可以根据表格设置更改公式中的单元格编号。
4]将(Place)光标放在所选单元格的右下角(在本例中为B14)。当光标变为加号图标(Plus icon)时,将其拖动到最后一个单元格。这会将整个公式复制并粘贴到所有单元格中,并为您提供最终值。
5]选择项目单元格的持续时间(Duration of the Project)正下方的单元格。输入(Enter)以下公式并按Enter:
=(INT(C2)-INT($B$2))-(INT(B2)-INT($B$2)
请(Please)正确填写公式中的单元格地址(如步骤3所述);否则,你会得到一个错误。
6]现在,将光标放在同一单元格的右下角并将其拖到最后。这会将整个公式复制并粘贴到所有单元格中,您将获得最终值。
7]现在,您必须插入一个堆积条形图(Stacked Bar Chart)。为此,选择两个表并转到“Insert > Chart”。你会得到一个正常的条形图。
8]您必须将普通条形图更改为堆叠条形图(Stacked Bar Chart)。选择图表,点击右上角的三个垂直点,然后点击“编辑图表(Edit Chart)”选项。这将打开Google 表格(Google Sheets)右侧的图表编辑窗口。
9]单击“设置(Set Up)”选项卡。之后,单击“图表类型(Chart Type)”中的下拉菜单。现在,向下滚动并选择“栏(Bar)”部分中的中间图表。这会将普通条形图更改为堆叠条形图(Stacked Bar Chart)。
10]现在,转到“自定义(Customize)”选项卡并展开“系列(Series)”部分。在下拉菜单中选择“开始日期”。(Starting Day)之后,单击“颜色(Color)”下拉菜单并选择“无(None)”。
您的甘特图(Gantt Chart)已准备就绪。如果需要,您可以使用“自定义(Customize)”选项将其设为 3D。
我们希望本文能帮助您创建甘特图(Gantt Chart)。
您可能还喜欢(You may also like):如何使用 Microsoft Excel 创建甘特图。
How to make a Gantt Chart in Google Sheets
If уou are a finance professional or a finance student, you might have heard about the Gantt Chart. Іt is a horizontal bar chart that is most commonly used in project management and planning. It shows the entіre projеct on a timeline. This is its most sіgnificant benefit. The Gantt Chart helps you analyze the following data:
- Beginning and end of each task,
- The total duration of each task,
- Deadlines of the project,
- The complete schedule of the projects from beginning to end, and more.
In this article, we will discuss the steps to create a Gantt Chart in Google Sheets.
How to make a Gantt Chart in Google Sheets
1] First, you have to create a new project in Google Sheets. Type your project data in three columns. Here, we have classified the data as Project Name, Start Date, and End Date. You can enter the data as per your choice. Now, complete your table by entering the project names and start and end dates.
2] Now, copy the first column and paste it below the table you created, leaving one row in between. Name the second column of the new table as Starting Day and the third column as Duration of the Project. See the below screenshot.
3] You have to apply a formula in the second column of the second table. For this, select the cell next to Project 1 in the second table. In our case, it is cell number B14. Write the following formula there and press Enter:
=INT(B2)-INT($B$2)
Do note that, in the above formula, we wrote B2 because the start date of Project 1 lies in the B2 cell. You can set change the cell number in the formula as per your table.
4] Place your cursor on the bottom right corner of the selected cell (in this case, it is B14). When your cursor changes to the Plus icon, drag it to the last cell. This will copy and paste the entire formula to all the cells and give you the final values.
5] Select the cell just below the Duration of the Project cell. Enter the following formula and press Enter:
=(INT(C2)-INT($B$2))-(INT(B2)-INT($B$2)
Please fill the cell address in the formula correctly (as described in step 3); otherwise, you will get an error.
6] Now, place your cursor on the bottom right corner of the same cell and drag it to the end. This will copy and paste the entire formula to all the cells, and you will get the final values.
7] Now, you have to insert a Stacked Bar Chart. For this, select both the tables and go to “Insert > Chart.” You will get a normal bar graph.
8] You have to change the normal bar graph to Stacked Bar Chart. Select the chart, click on the three vertical dots on the top right side, and then click on the “Edit Chart” option. This will open the chart editing window on the right side of the Google Sheets.
9] Click on the “Set Up” tab. After that, click on the drop-down menu in the “Chart Type.” Now, scroll down and select the middle chart in the “Bar” section. This will change the normal bar graph to the Stacked Bar Chart.
10] Now, go to the “Customize” tab and expand the “Series” section. Select “Starting Day” in the drop-down menu. After that, click on the “Color” drop-down menu and select “None.”
Your Gantt Chart is ready. If you want, you can make it 3D using the “Customize” option.
We hope this article helped you create a Gantt Chart.
You may also like: How to create Gantt Chart using Microsoft Excel.