{"id":23620,"date":"2020-10-01T12:53:32","date_gmt":"2020-10-01T12:53:32","guid":{"rendered":"https:\/\/toggl.com\/blog\/?p=23620"},"modified":"2026-02-23T12:39:56","modified_gmt":"2026-02-23T12:39:56","slug":"gantt-chart-google-sheets","status":"publish","type":"post","link":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets","title":{"rendered":"How to Make a Gantt Chart In Google Sheets (Free Templates)"},"content":{"rendered":"\n<p>Google Sheets is a powerful Excel alternative. However, it does not come with Gantt charts, so in this guide, we&#8217;ll explore how to create them using the built-in stacked bar chart in Google Sheets.<\/p>\n\n\n\n<p>Specifically, you&#8217;ll learn:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>What is a Gantt chart?<\/li>\n\n\n\n<li>What are its main elements?<\/li>\n\n\n\n<li>Pros &amp; cons of Google Sheets Gantt charts<\/li>\n\n\n\n<li>How to create a Gantt chart in Google Sheets?<\/li>\n\n\n\n<li>And, using free Google Sheets Gantt chart templates <\/li>\n<\/ul>\n\n\n\n<p>In addition, you&#8217;ll also learn about a simpler way to create Gantt charts that can be easily updated as and when plans change.<\/p>\n\n\n\n<p>Let&#8217;s get started.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What is a Gantt Chart?<\/h2>\n\n\n\n<p>A Gantt chart is a series of horizontal lines along a horizontal timeline that visually shows the planned and\/or done work.<\/p>\n\n\n\n<p>Because of its visual nature, a Gantt chart gives clear cues about what works needs to be done, and by when. Thus, helping bring more clarity to work.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"401\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/07\/toggl-plan-timeline.png\" alt=\"\" class=\"wp-image-21718\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/07\/toggl-plan-timeline.png 720w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/07\/toggl-plan-timeline-300x167.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Elements of a Gantt Chart<\/h3>\n\n\n\n<p>A Gantt chart has 5 major elements. These are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Timeline<\/strong>: The horizontal axis of the Gantt chart represents a <a href=\"https:\/\/toggl.com\/blog\/create-project-timeline\">project&#8217;s timeline<\/a>. Depending on the project, the timeline can be granular up to a day, week, or month.<\/li>\n\n\n\n<li><strong>Tasks<\/strong>: The vertical axis of the chart represents the project activities. Optionally, tasks can also be grouped into segments.<\/li>\n\n\n\n<li><strong>Bars<\/strong>: Horizontal bars on the chart represent when a task will be completed. These bars begin at the start date of a task. And, run parallel to the timeline for the duration of the task.<\/li>\n\n\n\n<li><strong>Milestones<\/strong>: Tasks are grouped into phases. A <a href=\"https:\/\/toggl.com\/blog\/project-milestones\">milestone<\/a> marks the end of a phase. And, a milestone is said to be achieved when all the tasks in the phase are done.<\/li>\n\n\n\n<li><strong>Resources<\/strong>: People, tools, and other resources are assigned to a task. That way allocation of resources can be managed better across tasks.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Pros &amp; cons of Google Sheets Gantt Charts<\/h3>\n\n\n\n<p>A Google Sheets Gantt chart is not very flexible. However, it comes with its own advantages. <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Easy to get started<\/strong>: With the familiar Microsoft Excel-like interface, Google Sheets is easy to get started for most managers.<\/li>\n\n\n\n<li><strong>Shareable<\/strong>: Unlike Excel, Google Sheets is shareable. This way, more than one person can work together on the same sheet.<\/li>\n\n\n\n<li><strong>Free<\/strong>: Google Sheets comes for free along with the Google Drive suite of office tools. <\/li>\n<\/ul>\n\n\n\n<p>On the other hand, Gantt charts created in Google sheets have the following disadvantages:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Not suitable for complex projects<\/strong>: With Google Sheets, it&#8217;s easy to visualize simple timelines. But, things can quickly become complex for projects with more than a few tasks. <\/li>\n\n\n\n<li><strong>Hard to keep up-to-date<\/strong>: Google Sheets are shareable, online spreadsheets. However, it can still become frustrating for multiple team members to collaboratively keep it updated.<\/li>\n\n\n\n<li><strong>No milestones<\/strong>: You cannot add milestones to Gantt Charts created using Excel or Google Sheets. And, as we&#8217;ve seen, milestones are important elements of a Gantt Chart. <\/li>\n\n\n\n<li><strong>One dimensional<\/strong>: Google Sheets or Excel Gant Charts are always from a task planning point of view. However, these charts fall flat when it comes to <a href=\"https:\/\/toggl.com\/blog\/resource-allocation\">managing resource allocation<\/a> along with task management.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">How to make a Gantt Chart in Google Sheets?<\/h2>\n\n\n\n<p>Because of these drawbacks, Google sheets is not an ideal tool to <a href=\"https:\/\/toggl.com\/blog\/create-project-timeline\">create a project timeline<\/a>.<\/p>\n\n\n\n<p>However, it may still make sense to use Google Sheets. Particularly, if you&#8217;re looking for a quick-fix solution to present a project&#8217;s timeline schedule. <\/p>\n\n\n\n<p>Alternatively, you can also use MS Excel. Learn <a href=\"https:\/\/toggl.com\/blog\/gantt-chart-excel\">how to create a Gantt chart in Excel<\/a>.<\/p>\n\n\n\n<p>Let&#8217;s look at the steps needed to create a Gantt chart in Google sheets.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step #1. Prepare the chart data<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"432\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-data.png\" alt=\"Step #1. Prepare Gantt chart data\" class=\"wp-image-23621\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-data.png 720w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-data-300x180.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-data-460x275.png 460w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-data-230x137.png 230w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/figure>\n\n\n\n<p>First, you need to prepare the data needed for the Gantt chart. You&#8217;ll need three columns:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Tasks<\/strong>: Project activities that appear on the Gantt chart.<\/li>\n\n\n\n<li><strong>Start Day<\/strong>: The day on which a task starts on the project timeline.<\/li>\n\n\n\n<li><strong>Duration<\/strong>: The duration in days to complete the task.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step #2. Insert a stacked bar chart<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"442\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-insert-chart.png\" alt=\"Step #2. Insert a stacked bar chart\" class=\"wp-image-23622\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-insert-chart.png 720w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-insert-chart-300x184.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/figure>\n\n\n\n<p>Second, we need to convert this data into a chart.<\/p>\n\n\n\n<p>As we saw earlier, Google Sheets does not come with a built-in Gantt chart. Instead, we&#8217;ll use a <em>stacked bar chart<\/em>. And, then we&#8217;ll customize it to look like a Gantt chart.<\/p>\n\n\n\n<p>To insert the stacked bar chart:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the prepared data.<\/li>\n\n\n\n<li>Then, click on <em>Insert > Chart<\/em>.  <\/li>\n<\/ul>\n\n\n\n<p>This should automatically insert a stacked bar chart. However, if it doesn&#8217;t, you can manually change the chart type. Here&#8217;s how:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on the chart to select it.<\/li>\n\n\n\n<li>Click on the three dots in the top-right corner, then click <em>Edit chart<\/em>.<\/li>\n\n\n\n<li>Select <em>Stacked bar chart<\/em> in <em>Chart editor > Setup > Chart Type<\/em><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"366\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-select-chart-type.png\" alt=\"Step #2a. Change the chart type to Stacked bar chart if it already isn't.\" class=\"wp-image-23623\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-select-chart-type.png 720w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-select-chart-type-300x153.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step #3. Customize the chart<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"368\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-set-start-day-color.png\" alt=\"Step #3. Customize the stacked bar chart to look like a Gantt chart.\" class=\"wp-image-23627\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-set-start-day-color.png 720w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-set-start-day-color-300x153.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/figure>\n\n\n\n<p>Finally, we need to format the stacked bar chart to look like a Gantt chart.<\/p>\n\n\n\n<p>To do that, we&#8217;ll change the color of the <em>Start Day<\/em> from the default <em>Blue<\/em> to <em>None<\/em>. Here&#8217;s how:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on the chart to select it.<\/li>\n\n\n\n<li>Click on the three dots in the top-right corner, then click <em>Edit chart<\/em>.<\/li>\n\n\n\n<li>Go to <em>Chart editor > Customize > Series<\/em> and select the <em>Start Day<\/em> series.<\/li>\n\n\n\n<li>Set the <em>Format > Color<\/em> to <em>None<\/em>.<\/li>\n<\/ul>\n\n\n\n<p>And that&#8217;s it. Your Gantt chart is ready.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"381\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart.png\" alt=\"Google Sheets Gantt Chart\" class=\"wp-image-23628\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart.png 720w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/google-sheets-gantt-chart-300x159.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Gantt Chart Template for Google Sheets<\/h2>\n\n\n\n<p>So far we&#8217;ve created a simple Gantt Chart using Gooogle Sheets. However, you cannot do much with it. If you&#8217;re looking for a comprehensive project Gantt Chart template, you may want to look at <a rel=\"noreferrer noopener\" aria-label=\"this template (opens in a new tab)\" href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1JcX4sHAuBRGsbXIgktxj5n72sMyFQutQyqJ7R_xQCCU\/edit?usp=sharing\" target=\"_blank\">this template<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"338\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/gantt-chart-google-sheets-template.png\" alt=\"Gantt Chart Google Sheets Template\" class=\"wp-image-23629\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/gantt-chart-google-sheets-template.png 720w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/gantt-chart-google-sheets-template-300x141.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/figure>\n\n\n\n<p>However, like any Google Sheets Gantt chart this detailed template has two major drawbacks:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>It&#8217;s hard to keep up-to-date. Delete a formula by mistake, and all your data goes for a toss.<\/li>\n\n\n\n<li>It&#8217;s great for looking at what task happens when. But, falls short when it comes to resource allocation.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Simple &amp; free alternative to Google Sheets Gantt Charts<\/h2>\n\n\n\n<p>You can make a Gantt Chart in Goggle Sheets or Excel quickly. However, these Gantt Charts are at best useful for presentations. <\/p>\n\n\n\n<p>Plus, managing a project from a spreadsheet is not such a great idea. It&#8217;s hard to work collaboratively, and yet keep the project information up-to-date.<\/p>\n\n\n\n<p>That&#8217;s where Toggl Focus can help:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"498\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/image-1024x498.png\" alt=\"\" class=\"wp-image-58150\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/image-1024x498.png 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/image-300x146.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/image-768x373.png 768w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/image-1536x747.png 1536w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/image-746x363.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/image-1152x560.png 1152w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/image-1500x729.png 1500w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/image-112x54.png 112w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/image.png 1598w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>With Toggl Focus you can:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create a Gantt Chart to <strong>plan a project&#8217;s schedule<\/strong>.<\/li>\n\n\n\n<li>Create a <strong>team workload timeline<\/strong> to manage resource allocation.<\/li>\n\n\n\n<li>Easy to use, drag &amp; drop interface to <strong>quickly add and update<\/strong> the Gantt chart timelines.<\/li>\n\n\n\n<li>Add <strong>milestones<\/strong> to deliver project phases on time.<\/li>\n\n\n\n<li>Assign tasks to <strong>multiple team members<\/strong>. Track progress as tasks move from <em>to-do<\/em> to <em>done<\/em>.<\/li>\n\n\n\n<li>Team members can <strong>collaborate on tasks<\/strong> using attachments and comments.<\/li>\n<\/ul>\n\n\n\n<p>Best of all, Toggl Focus is <strong><a href=\"https:\/\/toggl.com\/focus\/pricing\/\" type=\"link\" id=\"https:\/\/toggl.com\/focus\/pricing\/\">completely free for individual users<\/a><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Sheets does not come with Gantt charts. However, you can customize the built-in stacked bar chart to make one. Learn how.<\/p>\n","protected":false},"author":638,"featured_media":23635,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[851],"tags":[],"class_list":["post-23620","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-project-management"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Make a Gantt Chart In Google Sheets (Free Templates)<\/title>\n<meta name=\"description\" content=\"Google Sheets does not come with Gantt charts. However, you can customize the built-in stacked bar chart to make one. Learn how.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Make a Gantt Chart In Google Sheets (Free Templates)\" \/>\n<meta property=\"og:description\" content=\"Google Sheets does not come with Gantt charts. However, you can customize the built-in stacked bar chart to make one. Learn how.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets\" \/>\n<meta property=\"og:site_name\" content=\"Toggl Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Toggl\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-01T12:53:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-23T12:39:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/gantt-charts-google-sheets.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"719\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Elizabeth Thorn\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@toggl\" \/>\n<meta name=\"twitter:site\" content=\"@toggl\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elizabeth Thorn\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#article\",\"isPartOf\":{\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets\"},\"author\":{\"name\":\"Elizabeth Thorn\",\"@id\":\"https:\/\/toggl.com\/blog\/#\/schema\/person\/97924920bc23cf18214d8557f014c2a4\"},\"headline\":\"How to Make a Gantt Chart In Google Sheets (Free Templates)\",\"datePublished\":\"2020-10-01T12:53:32+00:00\",\"dateModified\":\"2026-02-23T12:39:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets\"},\"wordCount\":1109,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/toggl.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#primaryimage\"},\"thumbnailUrl\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/gantt-charts-google-sheets.jpg\",\"articleSection\":[\"Project Management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets\",\"url\":\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets\",\"name\":\"How to Make a Gantt Chart In Google Sheets (Free Templates)\",\"isPartOf\":{\"@id\":\"https:\/\/toggl.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#primaryimage\"},\"image\":{\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#primaryimage\"},\"thumbnailUrl\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/gantt-charts-google-sheets.jpg\",\"datePublished\":\"2020-10-01T12:53:32+00:00\",\"dateModified\":\"2026-02-23T12:39:56+00:00\",\"description\":\"Google Sheets does not come with Gantt charts. However, you can customize the built-in stacked bar chart to make one. Learn how.\",\"breadcrumb\":{\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#primaryimage\",\"url\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/gantt-charts-google-sheets.jpg\",\"contentUrl\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/gantt-charts-google-sheets.jpg\",\"width\":1200,\"height\":719,\"caption\":\"How to create a Gantt chart with Google Sheets?\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/toggl.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Make a Gantt Chart In Google Sheets (Free Templates)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/toggl.com\/blog\/#website\",\"url\":\"https:\/\/toggl.com\/blog\/\",\"name\":\"Toggl Blog\",\"description\":\"Everything works much better with Toggl\",\"publisher\":{\"@id\":\"https:\/\/toggl.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/toggl.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/toggl.com\/blog\/#organization\",\"name\":\"Toggl\",\"url\":\"https:\/\/toggl.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/toggl.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/10\/toggl-logo.png\",\"contentUrl\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/10\/toggl-logo.png\",\"width\":814,\"height\":814,\"caption\":\"Toggl\"},\"image\":{\"@id\":\"https:\/\/toggl.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Toggl\/\",\"https:\/\/x.com\/toggl\",\"https:\/\/www.instagram.com\/usetoggl\/\",\"https:\/\/www.linkedin.com\/company\/toggl\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/toggl.com\/blog\/#\/schema\/person\/97924920bc23cf18214d8557f014c2a4\",\"name\":\"Elizabeth Thorn\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/3b7b3006f2daa6d9c269e92e85739d1552469a2de4b4d2ccaca714e5d9f421a7?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3b7b3006f2daa6d9c269e92e85739d1552469a2de4b4d2ccaca714e5d9f421a7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3b7b3006f2daa6d9c269e92e85739d1552469a2de4b4d2ccaca714e5d9f421a7?s=96&d=mm&r=g\",\"caption\":\"Elizabeth Thorn\"},\"description\":\"Elizabeth is an experienced entrepreneur, writer, and content marketer. She has nine years of experience helping grow businesses, including two of her own, and shares Toggl's mission of challenging traditional beliefs about what building a successful business looks like.\",\"url\":\"https:\/\/toggl.com\/blog\/author\/elizabeth\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Make a Gantt Chart In Google Sheets (Free Templates)","description":"Google Sheets does not come with Gantt charts. However, you can customize the built-in stacked bar chart to make one. Learn how.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets","og_locale":"en_US","og_type":"article","og_title":"How to Make a Gantt Chart In Google Sheets (Free Templates)","og_description":"Google Sheets does not come with Gantt charts. However, you can customize the built-in stacked bar chart to make one. Learn how.","og_url":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets","og_site_name":"Toggl Blog","article_publisher":"https:\/\/www.facebook.com\/Toggl\/","article_published_time":"2020-10-01T12:53:32+00:00","article_modified_time":"2026-02-23T12:39:56+00:00","og_image":[{"width":1200,"height":719,"url":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/gantt-charts-google-sheets.jpg","type":"image\/jpeg"}],"author":"Elizabeth Thorn","twitter_card":"summary_large_image","twitter_creator":"@toggl","twitter_site":"@toggl","twitter_misc":{"Written by":"Elizabeth Thorn","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#article","isPartOf":{"@id":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets"},"author":{"name":"Elizabeth Thorn","@id":"https:\/\/toggl.com\/blog\/#\/schema\/person\/97924920bc23cf18214d8557f014c2a4"},"headline":"How to Make a Gantt Chart In Google Sheets (Free Templates)","datePublished":"2020-10-01T12:53:32+00:00","dateModified":"2026-02-23T12:39:56+00:00","mainEntityOfPage":{"@id":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets"},"wordCount":1109,"commentCount":0,"publisher":{"@id":"https:\/\/toggl.com\/blog\/#organization"},"image":{"@id":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#primaryimage"},"thumbnailUrl":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/gantt-charts-google-sheets.jpg","articleSection":["Project Management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets","url":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets","name":"How to Make a Gantt Chart In Google Sheets (Free Templates)","isPartOf":{"@id":"https:\/\/toggl.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#primaryimage"},"image":{"@id":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#primaryimage"},"thumbnailUrl":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/gantt-charts-google-sheets.jpg","datePublished":"2020-10-01T12:53:32+00:00","dateModified":"2026-02-23T12:39:56+00:00","description":"Google Sheets does not come with Gantt charts. However, you can customize the built-in stacked bar chart to make one. Learn how.","breadcrumb":{"@id":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/toggl.com\/blog\/gantt-chart-google-sheets"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#primaryimage","url":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/gantt-charts-google-sheets.jpg","contentUrl":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/10\/gantt-charts-google-sheets.jpg","width":1200,"height":719,"caption":"How to create a Gantt chart with Google Sheets?"},{"@type":"BreadcrumbList","@id":"https:\/\/toggl.com\/blog\/gantt-chart-google-sheets#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/toggl.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Make a Gantt Chart In Google Sheets (Free Templates)"}]},{"@type":"WebSite","@id":"https:\/\/toggl.com\/blog\/#website","url":"https:\/\/toggl.com\/blog\/","name":"Toggl Blog","description":"Everything works much better with Toggl","publisher":{"@id":"https:\/\/toggl.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/toggl.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/toggl.com\/blog\/#organization","name":"Toggl","url":"https:\/\/toggl.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/toggl.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/10\/toggl-logo.png","contentUrl":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/10\/toggl-logo.png","width":814,"height":814,"caption":"Toggl"},"image":{"@id":"https:\/\/toggl.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Toggl\/","https:\/\/x.com\/toggl","https:\/\/www.instagram.com\/usetoggl\/","https:\/\/www.linkedin.com\/company\/toggl"]},{"@type":"Person","@id":"https:\/\/toggl.com\/blog\/#\/schema\/person\/97924920bc23cf18214d8557f014c2a4","name":"Elizabeth Thorn","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3b7b3006f2daa6d9c269e92e85739d1552469a2de4b4d2ccaca714e5d9f421a7?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3b7b3006f2daa6d9c269e92e85739d1552469a2de4b4d2ccaca714e5d9f421a7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3b7b3006f2daa6d9c269e92e85739d1552469a2de4b4d2ccaca714e5d9f421a7?s=96&d=mm&r=g","caption":"Elizabeth Thorn"},"description":"Elizabeth is an experienced entrepreneur, writer, and content marketer. She has nine years of experience helping grow businesses, including two of her own, and shares Toggl's mission of challenging traditional beliefs about what building a successful business looks like.","url":"https:\/\/toggl.com\/blog\/author\/elizabeth"}]}},"_links":{"self":[{"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/posts\/23620","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/users\/638"}],"replies":[{"embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/comments?post=23620"}],"version-history":[{"count":19,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/posts\/23620\/revisions"}],"predecessor-version":[{"id":58151,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/posts\/23620\/revisions\/58151"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/media\/23635"}],"wp:attachment":[{"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/media?parent=23620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/categories?post=23620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/tags?post=23620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}