创建Google Docs 甘特(Google Docs Gantt)图可能是一个有用的项目管理工具。甘特(Gantt)图可以帮助您为项目的时间线和进度建立视觉上下文。您也可以使用其他程序来创建甘特(Gantt)图,但它们可能很复杂,尤其是对于像客户评论这样的事情。
您也可以在Excel中创建(Excel)甘特(Gantt)图,但可以通过云轻松访问Google Docs 甘特图。(Google Docs Gantt)您可以允许授权成员进行编辑访问,这样他们就可以协作处理 Google 文档(collaborate on a Google Doc),而无需通过电子邮件来回发送电子表格。
创建 Google 文档甘特图
在开始创建Google 文档甘特(Google Docs Gantt)图之前,您需要使用一些数据 填充Google工作表。(Google)
- (Set)在Google工作表中(Google)设置您的任务,以便您以表格形式获得项目的日程安排。列出项目的任务,并为每个任务分配开始和结束日期。
- 您的下一步是设置另一个表格,您将在其中列出特定任务的开始日期以及完成所需的天数。例如,第一个任务“源材料”从第 0 天开始,持续 13 天。
以下是准备每一列的方法:
- 任务(Tasks):只需从上一个表中复制此列。
- Start Task on Day #:在这里,您需要在项目时间线中的第 n 天开始特定任务。因此,您基本上需要计算:
[任务的开始日期(Start Date)- 第一个任务的开始日期(Start Date)]
在此示例中,应在相关单元格中输入以下公式:
=int(D5)-int($D$5)
输入公式后,您可以通过拖动边框选择将公式应用于其余单元格。公式中的美元符号可帮助您在将公式应用于其他单元格时 保留单元格引用。(preserve a cell reference)
该公式将两个日期之间的差异(difference between two dates)计算为整数(这就是INT函数所做的)。如果没有INT函数,您可能会收到带有十进制值的输出。
如果您在输入此公式后看到 1900 年代的日期,请确保您已将单元格格式设置为数字而不是日期。
- # of Days on Task:在这里,您将根据项目时间表计算每个任务花费的天数。您可以将其计算为:
[任务的结束日期(Date)- 第一个任务的开始日期(Start Date)] - [任务的开始日期(Start Date)- 第一个任务的开始日期(Start Date)]
在此示例中,用于计算任务花费天数的公式是:
=(int(E5)-int($D$5))-(int(D5)-int($D$5))
请务必将两个减法运算括在括号中。否则,您可能会收到不正确的输出。
完成后,拖动边框选择以将公式应用于其余单元格,就像您对上一列所做的那样。此外,请确保单元格的格式设置为显示数字而不是日期。
- 选择您刚刚创建的整个表格,然后从顶部功能区中 选择“插入(Insert)” > “图表”。(Chart)
- 您现在将在屏幕上看到一个图表,并在屏幕右侧看到一个图表编辑器。(Chart)在图表编辑器的设置(Setup )选项卡下选择图表类型。(Chart type)
- 图表类型列表将出现在图表(Chart)编辑器中。滚动(Scroll)并查找Bar部分。从此部分中,选择堆积条形图(Stacked Bar Chart)。
- 接下来,切换到自定义(Customize)选项卡。展开系列(Series)部分并选择Start Task on Day # 系列。将填充不透明度(Fill Opacity)和线条不透明度(Line Opacity)设置为 0% 以将其从图表中隐藏。
这就是创建Google Docs 甘特(Google Docs Gantt)图所需的全部内容。如果你愿意,你可以进一步定制它。您可以重命名图表、命名水平轴和垂直轴,并在“自定义”选项卡中探索其他自定义(Customize)选项。
使用附加组件创建Google Docs 甘特图(Google Docs Gantt Chart)
如果您不想花时间手动创建Google Docs 甘特(Google Docs Gantt)图,您可以随时使用可用于 Google Docs 的几个甘特(Gantt)图插件之一(add-ons available for Google Docs)。
要下载加载项,请从顶部功能区中选择加载项,然后选择获取(Add-ons)加载项(Get add-ons)。搜索甘特图(Gantt chart)。选择Slick Gantt >安装(Install)。您也可以选择另一个,但Slick Gantt是一款简单易用的工具。
安装插件后,返回您的Google表格。在使用Slick Gantt(Slick Gantt)之前,您需要注意两个注意事项。
您首先需要重新定位数据。如果还没有,请将数据从单元格 A1 开始放置,否则Slick Gantt将无法在工作表中找到数据。
此外,您还需要在数据中添加一个Task ID列,因为该插件至少需要四个字段(Task ID、Task Name、Start Date和End Date)。
正确放置数据并添加任务 ID(Task ID)列后:
- 从顶部功能区中选择附加组件,然后选择Slick Gantt (Add-ons)>(Slick Gantt ) Gantt chart(Gantt chart)。
- 该插件现在将为您加载甘特(Gantt)图。
- 如果您想通过电子邮件将甘特(Gantt)图发送给您的团队,您也可以通过单击顶部的图片图标将其作为图片下载。
您可以使用其他几个附加组件来代替Slick Gantt:
- (Gantt Chart by AddonForge)如果您需要一个包含所有花里胡哨的插件,AddonForge 的甘特图是一个很好的工具。但是,许多功能仅限于付费版本。
- Takuya Tokiwa 的甘特图生成器是另一个干净简单的插件,它提供了(Gantt Chart Generator by Takuya Tokiwa )甘特(Gantt)图工具中您想要的大多数功能。
- Awesome Gapps 的 Awesome Table(Awesome Table by Awesome Gapps)可以做很多事情,创建甘特(Gantt)图就是其中之一。如果您需要一个不仅仅是创建图表的工具,那么这是一个很棒的工具。
您的Google 文档甘特图(Google Docs Gantt Chart)已准备就绪
设置图表后,您可以通过更新工作表中的数据来实时更新它。就像这有多容易?如果这与您的工作更相关,您也可以尝试在 Google 表格中制作散点图。(making a scatter plot in Google Sheets)
How to Add a Gantt Chart in Google Docs
Creating a Google Docs Gantt chart can be a useful project management tool. Gantt chartѕ can help you establish visual context for your project’s timeline and progress. You can use other programs for creating Gantt charts as well, bυt they can be complex, еspecially for sоmething like a client review.
You can also create a Gantt chart in Excel, but a Google Docs Gantt chart is readily accessible over the cloud. You can allow authorized members edit access so they can collaborate on a Google Doc without having to send the spreadsheet back and forth via email.
Create a Google Docs Gantt Chart
Before you get started with creating a Google Docs Gantt chart, you need to populate the Google worksheet with some data.
- Set up your tasks in a Google sheet so you have your project’s schedule in table form. List out the tasks of the project and assign a start and end date to each task.
- Your next step is to set up another table where you’ll list the day on which a certain task will begin and the number of days it will take to complete. For instance, the first task “Source Materials” starts on day 0 and goes on for 13 days.
Here’s how you can prepare each column:
- Tasks: Just copy this column from the previous table.
- Start Task on Day #: Here, you’ll want the nth day in your project’s timeline when a particular task is supposed to begin. So, you’ll essentially need to compute:
[A Task’s Start Date – The First Task’s Start Date]
In this example, the following formula should be entered in the relevant cell:
=int(D5)-int($D$5)
Once you’ve entered the formula, you can apply the formula to the remaining cells by dragging the border selection. The dollar sign in the formula helps you preserve a cell reference when you apply the formula to other cells.
The formula calculates the difference between two dates as an integer (that’s what the INT function does). Without the INT function, you may receive an output with a decimal value.
If you see a date in the 1900s after entering this formula, make sure that you’ve formatted the cell as a number and not a date.
- # of Days on Task: Here, you’ll calculate the number of days to be spent on each task as per your project timeline. You can compute this as:
[A Task’s End Date – The First Task’s Start Date] – [The Task’s Start Date – The First Task’s Start Date]
In this example, the formula use to compute the number of days spent on a task is:
=(int(E5)-int($D$5))-(int(D5)-int($D$5))
Be sure to enclose the two subtracting operations in parentheses. Otherwise, you could receive an incorrect output.
When done, drag the border selection to apply formulas to the rest of the cells, just like you did for the previous column. Also, make sure the cells are formatted to display a number and not a date.
- Select the entire table that you just created and select Insert > Chart from the top ribbon.
- You’ll now see a chart on your screen and a Chart editor at the right of your screen. Select Chart type under the Setup tab in Chart editor.
- A list of chart types will appear in the Chart editor. Scroll through and look for the Bar section. From this section, select a Stacked Bar Chart.
- Next, switch to the Customize tab. Expand the Series section and select the Start Task on Day # series. Set Fill Opacity and Line Opacity to 0% to hide it from the chart.
That’s all you need to create a Google Docs Gantt chart. If you want, you can customize it further. You can rename the chart, name the horizontal and vertical axis, and explore other customization options in the Customize tab.
Create a Google Docs Gantt Chart with an Add-On
If you don’t want to spend time manually creating a Google Docs Gantt chart, you can always use one of the several Gantt chart add-ons available for Google Docs.
To download an add-on, select Add-ons from the top ribbon, and select Get add-ons. Search for Gantt chart. Select Slick Gantt > Install. You could just as well select another one, but Slick Gantt is a no-fuss, easy to use tool.
Once you’ve installed the add-on, go back to your Google sheet. There are two caveats you need to take care of before using Slick Gantt.
You’ll first need to reposition your data. If you haven’t already, place the data such that it starts from cell A1, otherwise Slick Gantt will have trouble finding the data in your sheet.
Plus, you’ll also need to add a Task ID column to your data since the add-on requires at least four fields (Task ID, Task Name, Start Date, and End Date).
Once you’ve placed the data appropriately and added a Task ID column:
- Select Add-ons from the top ribbon and select Slick Gantt > Gantt chart.
- The add-on will now load a Gantt chart for you.
- If you want to email the Gantt chart to your team, you can also download it as a picture by clicking on the picture icon at the top.
There are several other add-ons you can use instead of Slick Gantt:
- Gantt Chart by AddonForge is a great tool if you need an add-on with all the bells and whistles. However, a lot of features are restricted to the paid version.
- Gantt Chart Generator by Takuya Tokiwa is another clean and simple add-on, and offers most features you’d want in a Gantt chart tool.
- Awesome Table by Awesome Gapps can do a number of things, and creating Gantt charts is one of them. If you need a tool that does a lot more than just create charts, this is a great tool.
Your Google Docs Gantt Chart Is Ready
Once you’ve set up the chart, you can update it in real-time by updating the data in the sheet. Like how easy this was? You can also try making a scatter plot in Google Sheets, if that’s more relevant to your work.