[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
In its most basic form, a Gantt chart is a bar chart showing tasks and time \u2013 or a schedule of what activities need doing and when. More advanced versions include other information such as who is responsible for each task, how different tasks relate to each other (dependencies) and what resources are required.<\/p>\n
Because it’s cloud-based (online) software, Google Sheets always contains real-time data and every change is saved automatically. This means that the entire team can make updates to the same file from any location, at any time.<\/p>\n
This guide shows you how to make a Gantt chart in Google Sheets from a stacked bar chart, step by step, and how to link tasks with dependencies. If you’d rather start from a ready-made Google Sheets Gantt chart, use the template in the next section.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
A project management template saves you the setup. The one below is a master sheet with a WBS tab and a Gantt tab, and it lets you:<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
Google Sheets has powerful collaboration functions. But if you’re managing a complex project or multiple projects, you might not want multiple colleagues working on (and changing) the same spreadsheet. As a project manager, it’s already a challenge to keep track of everything. And it’s often safer and more streamlined if you keep data flows segregated.<\/p>\n
The Sheetgo Project Management workflow template contains input sheets for your colleagues. Here they can update the status of their tasks. The data from these input sheets flows automatically (via Sheetgo connections) straight into your master sheet. Likewise, when you enter or update task information in your master sheet (such as extending the end date) that data is automatically exported to your team’s spreadsheets.<\/p>\n
Check out the Sheetgo project management template<\/a>. If you’d rather not keep the sheet up to date yourself, Sheetgo also has Milo<\/a>, an AI virtual employee who assigns tasks, maps dependencies, and keeps the project sheet current. He works in the spreadsheets your team already uses and checks with a person before anything consequential.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/gantt-chart-in-google-sheets-3.png” alt=”Gantt chart template for Google Sheets \u2014 collaborator files and the project management master sheet exchanging task updates” title_text=”Collaborator files and the project management master sheet exchanging task updates” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Get an at-a-glance overview of your project timeline in the automated Gantt chart:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/gantt-chart-in-google-sheets-4.png” alt=”Gantt chart template for Google Sheets \u2014 Gantt tab with each task’s status, percent done, and weekly timeline bars” title_text=”Gantt tab with each task’s status, percent done, and weekly timeline bars” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-make-a-gantt-chart-in-google-shee” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Gantt charts can be intimidating if you don\u2019t know the components or what you can achieve with them. However, once you understand these components and how they work together, you\u2019ll be able to create your own. Follow the steps below to create a Gantt chart in Google Sheets.<\/p>\n Open Google Sheets and go to the sheet where you want your Gantt chart. The first step is to build a table to keep track of the start and end dates for each task, which we will use to work out the start day and the duration of each task.<\/p>\n 1.<\/strong> First, add the headers you need for the table: task, start date, end date, start day, and duration.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-add-headers.webp” alt=”Gantt chart in Google Sheets \u2014 headers task, start date, end date, start day, and duration in row 1″ title_text=”Headers task, start date, end date, start day, and duration in row 1″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Select the columns with the start and end dates. Go to Format > Number > Date.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-format-dates.webp” alt=”Gantt chart in Google Sheets \u2014 Date number format picked from the Format menu for the start date column” title_text=”Date number format picked from the Format menu for the start date column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that you\u2019ve set up the table, you need to add your project data. You\u2019ll need to add each task to the table, starting with the earliest task.<\/p>\n 1.<\/strong> In the first column, add the relevant task names.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-task-name.webp” alt=”Gantt chart in Google Sheets \u2014 task names taskname1 to taskname9 in column A” title_text=”Task names taskname1 to taskname9 in column A” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> In the second column, add the start date for each task.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-start-date.webp” alt=”Gantt chart in Google Sheets \u2014 start dates from 2\/1\/2023 to 2\/16\/2023 in column B” title_text=”Start dates from 2\/1\/2023 to 2\/16\/2023 in column B” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> In the third column, add the end date for each task.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-end-date.webp” alt=”Gantt chart in Google Sheets \u2014 end dates from 2\/4\/2023 to 2\/21\/2023 in column C” title_text=”End dates from 2\/4\/2023 to 2\/21\/2023 in column C” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Using the data added in the previous step, you can work out the start day and duration of each task. Fortunately, Google Sheets has a very useful function to do this for you: the DATEDIF function<\/a>. For the start day, we need the difference between each task\u2019s start date and the earliest start date, which is the start date for task 1.<\/p>\n 1.<\/strong> To calculate the start day, type in the DATEDIF function.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-datedif-start-day.webp” alt=”Google Sheets Gantt chart \u2014 DATEDIF typed in the first start day cell, D2″ title_text=”DATEDIF typed in the first start day cell, D2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> The first parameter is the start date for the project, which is the same as the start date for the first task. Use absolute referencing for the start date so you can copy the formula down.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-1st-parameter.webp” alt=”Google Sheets Gantt chart \u2014 $B$2 entered as the DATEDIF start date” title_text=”$B$2 entered as the DATEDIF start date” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> For the second parameter (end_date), select the first task’s start date, but with relative referencing – no dollar symbols – so that you can copy the formula down to the other tasks.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-2nd-parameter.webp” alt=”Google Sheets Gantt chart \u2014 B2 entered as the DATEDIF end date” title_text=”B2 entered as the DATEDIF end date” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> The last parameter indicates the unit, so you need to use \u201cD\u201d to get the result in days.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-3rd-parameter.webp” alt=”Google Sheets Gantt chart \u2014 finished start day formula with D as the unit in cell D2″ title_text=”Finished start day formula with D as the unit in cell D2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> You can use the suggested autofill or simply grab the cell\u2019s fill handle and drag it down to the last task.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-copy-formula.webp” alt=”Google Sheets Gantt chart \u2014 suggested autofill for the rest of the start day column” title_text=”Suggested autofill for the rest of the start day column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 6.<\/strong> You can also use the DATEDIF function to find the tasks\u2019 duration. However, make sure you don\u2019t use absolute referencing for any of the parameters.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-datedif-duration.webp” alt=”Google Sheets Gantt chart \u2014 DATEDIF of B2 and C2 in days for the first task’s duration” title_text=”DATEDIF of B2 and C2 in days for the first task’s duration” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 7.<\/strong> As before, accept the selected autofill or grab the fill handle to copy down to the last task.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-copy-formula-2.webp” alt=”Google Sheets Gantt chart \u2014 suggested autofill for the rest of the duration column” title_text=”Suggested autofill for the rest of the duration column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now that you have all the required data, it’s time to add a stacked bar chart<\/a>.<\/p>\n 1.<\/strong> Select the columns with the task, the start day, and the duration.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-select-data.webp” alt=”Make a Gantt chart in Google Sheets \u2014 task, start day, and duration columns selected” title_text=”Task, start day, and duration columns selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to Insert > Chart.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-insert-chart.webp” alt=”Make a Gantt chart in Google Sheets \u2014 Chart in the Insert menu” title_text=”Chart in the Insert menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> In the chart editor, select the stacked bar chart type.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-stacked-bar-chart.webp” alt=”Make a Gantt chart in Google Sheets \u2014 Stacked bar chart picked as the chart type in the Setup tab” title_text=”Stacked bar chart picked as the chart type in the Setup tab” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n A few modifications will convert your bar chart into a Gantt chart.<\/p>\n 1.<\/strong> In the \u2018Customize\u2019 tab in the chart editor, click \u2018Chart & axis titles\u2019 to type in your preferred title.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-edit-title.webp” alt=”Make a Gantt chart in Google Sheets \u2014 chart title Project Gantt Chart typed in the Customize tab” title_text=”Chart title Project Gantt Chart typed in the Customize tab” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to \u2018Series\u2019 and change the color of the first series, start day.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-edit-1st-series.webp” alt=”Gantt chart in Google Sheets \u2014 start day series set to no fill color, leaving only the duration bars” title_text=”Start day series set to no fill color, leaving only the duration bars” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Next, click \u2018Legend\u2019 and select \u2018None\u2019 as shown below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-remove-legend.webp” alt=”Gantt chart in Google Sheets \u2014 legend position set to None” title_text=”Legend position set to None” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Select the vertical axis title and delete the text to remove it.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-remove-axis-title.webp” alt=”Gantt chart in Google Sheets \u2014 vertical axis title selected under Chart and axis titles” title_text=”Vertical axis title selected under Chart and axis titles” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 5.<\/strong> Your chart now looks like a traditional Gantt chart. However, you can modify it further to match your style guide.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-gantt-chart.webp” alt=”Gantt chart in Google Sheets \u2014 finished Gantt chart next to the task table” title_text=”Finished Gantt chart next to the task table” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”gantt-chart-with-dependencies-in-google” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n There are four different types of dependencies you can add to your Gantt chart. Follow the instructions below to add different types of dependencies to your Gantt chart.<\/p>\n This kind of dependency refers to tasks that need to be finished for another task to start. In this example, the third task cannot begin until the first is completed.<\/p>\n 1.<\/strong> In the cell corresponding to the third task\u2019s start date, type in the MAX function and select the first task\u2019s end date. Add 1 to ensure the task starts the next day.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-use-max.webp” alt=”Gantt chart with dependencies in Google Sheets \u2014 =MAX(C2)+1 in the third task’s start date” title_text=”=MAX(C2)+1 in the third task’s start date” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> The third task\u2019s start date now depends on the first task\u2019s end date.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-dependency-added.webp” alt=”Gantt chart with dependencies in Google Sheets \u2014 third task now starting 2\/5\/2023, the day after the first task ends” title_text=”Third task now starting 2\/5\/2023, the day after the first task ends” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This type of dependency refers to tasks that must be started before another task can be finished. In this example, the fifth task cannot be completed until the sixth has started.<\/p>\n In this case, you need to use the MIN function for the fifth task\u2019s end date, then add 1.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-min-function.webp” alt=”Gantt chart with dependencies in Google Sheets \u2014 =MIN(B7)+1 in the fifth task’s end date” title_text=”=MIN(B7)+1 in the fifth task’s end date” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This type of dependency occurs when a task must start before another task can start. In this example, the fifth task must start before the sixth can begin.<\/p>\n Here, the sixth task’s start date is =MAX(B6)+3, so it starts three days after the fifth task.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-use-max-2.webp” alt=”Gantt chart with dependencies in Google Sheets \u2014 =MAX(B6)+3 in the sixth task’s start date” title_text=”=MAX(B6)+3 in the sixth task’s start date” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The final type of dependency requires that one task finishes before the other can finish. In this case, the eighth task must be completed before the ninth can finish.<\/p>\n Here, the ninth task’s end date is =MIN(C9)+3, so it ends three days after the eighth task.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-use-min.webp” alt=”Gantt chart with dependencies in Google Sheets \u2014 =MIN(C9)+3 in the ninth task’s end date” title_text=”=MIN(C9)+3 in the ninth task’s end date” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n That\u2019s it. You can add as many dependencies as you need.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/gantt-chart-google-sheets-dependencies-added.webp” alt=”Gantt chart with dependencies in Google Sheets \u2014 chart redrawn after adding all four dependencies” title_text=”Chart redrawn after adding all four dependencies” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Every project has 5 key stages or “groups”:<\/p>\n These groups are then divided into subgroups, and subgroups are divided into tasks. For example, your Group might be “Planning”, your subgroup might be “Communications Plan,” and your task might be “Define communication channels”.<\/p>\n Each task is usually allocated to an owner (the individual responsible for completing it).<\/p>\n Gantt charts and other project management tools often use a WBS. This stands for work breakdown structure. It\u2019s a method for organizing a project in manageable, deliverable sections. A WBS has a hierarchical, tree-like structure, meaning that you break one large project down into smaller, achievable tasks. In your Gantt chart, a WBS helps you name and identify tasks (and their relation to each other) in this logical way.<\/p>\n For example, Planning (group) could be allocated the WBS number 2<\/strong>. In that case, Communications plan (your subgroup) might be 2.3<\/strong> and Define communications channels (your task) might be 2.3.1<\/strong>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/gantt-chart-in-google-sheets-1.png” alt=”Gantt chart in Google Sheets \u2014 WBS tab of a project management master sheet with WBS IDs, dependencies, owners, and dates” title_text=”WBS tab of a project management master sheet with WBS IDs, dependencies, owners, and dates” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Google Docs has no Gantt chart type, so build the chart in Google Sheets first with the steps above. Then, in your document, go to Insert > Chart > From Sheets, pick the spreadsheet, select the Gantt chart, keep Link to spreadsheet checked, and click Import. When the dates change in your sheet, click Update on the chart in the document to refresh it. Both apps run in the browser, so you don’t need to install anything.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you focus on project management in your work, you might want to invest in more advanced Gantt software such as TeamGantt<\/a> or\u00a0GanttPro.<\/a><\/p>\n These applications help you plan, manage and collaborate on projects, with an attractive interface for presentation. If you need to share Gantt charts and project visualizations with external stakeholders, it might be worth paying for this type of software.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Creating a Gantt chart in Google Sheets is not that scary. If you follow the steps, it’s a straightforward process. There will be dependent or concurrent tasks in almost any project, and the Gantt chart allows you to reflect that. You now know how to create a simple Gantt chart in Google Sheets, how to customize it to your needs and preferences, and how to add dependencies.<\/p>\n To skip the setup next time, start from the template at the top of this guide. Our post on the project management template in Google Sheets<\/a> shows how to set it up, and if your team works in Excel, there’s a Gantt chart Excel template<\/a> too.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" In its most basic form, a Gantt chart is a bar chart showing tasks and time \u2013 or a schedule of what activities need doing and when. More advanced versions include other information such as who is responsible for each task, how different tasks relate to each other (dependencies) and what resources are required.Because it’s […]<\/p>\n","protected":false},"author":39,"featured_media":22648,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[47],"tags":[46],"class_list":["post-22520","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-project-management-processes","tag-project-management"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/22520","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=22520"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/22520\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/22648"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=22520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=22520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=22520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to make a Gantt chart in Google Sheets<\/h2>\n
Set up the table<\/h3>\n
Add your project data<\/h3>\n
Calculate the start day and duration<\/h3>\n
Add a stacked bar chart<\/h3>\n
Turn the bar chart into a Gantt chart<\/h3>\n
Gantt chart with dependencies in Google Sheets<\/h2>\n
Finish-to-start<\/h3>\n
Start-to-finish<\/h3>\n
Start-to-start<\/h3>\n
Finish-to-finish<\/h3>\n
How to structure your project in a Gantt chart<\/h2>\n
\n
Using a WBS for project management<\/h3>\n
How to add a Gantt chart to Google Docs<\/h2>\n
Looking for specialist Gantt software?<\/h2>\n
Conclusion<\/h2>\n