{"id":28114,"date":"2021-01-25T14:55:36","date_gmt":"2021-01-25T14:55:36","guid":{"rendered":"https:\/\/staging-mondaycomblog.kinsta.cloud\/?post_type=pm&#038;p=28114"},"modified":"2024-07-07T11:12:55","modified_gmt":"2024-07-07T11:12:55","slug":"gantt-chart-in-excel","status":"publish","type":"post","link":"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/","title":{"rendered":"Making Gantt charts in Excel [free Excel Gantt chart template]"},"content":{"rendered":"<p><a href=\"https:\/\/monday.com\/blog\/project-management\/everything-you-want-to-know-about-gantt-charts\/\">Gantt charts<\/a> are a project manager\u2019s bread and butter. They indicate who\u2019s working on which tasks, dates and durations, crossovers or delays, and everything in between. Gantt charts make life easy for teams trying to get big project plans done. Unfortunately, creating one is challenging without the right <a href=\"https:\/\/monday.com\/blog\/project-management\/13-top-gantt-chart-software\/\">Gantt tools<\/a> or the right excel Gantt chart template.<\/p>\n<blockquote><p>The best way to build a Gantt chart is using a Work OS like <a href=\"https:\/\/monday.com\/solutions\/gantt-chart\" target=\"_blank\" rel=\"noopener noreferrer\">monday.com<\/a>. But if you\u2019re offline or don&#8217;t mind a less customizable approach, you can also create a Gantt chart in Excel.<\/p><\/blockquote>\n<p style=\"text-align: center;\"><a class=\"cta-button blue-button\" aria-label=\"Get template\" href=\"http:\/\/auth.monday.com\/solutions\/add_solution?solution_id=122904\" target=\"_self\">Get template<\/a><\/p>\n<p>We&#8217;ll explain how to create a Gantt chart in Excel on a PC or a Mac and the easiest way to make a Gantt chart. We&#8217;ll also include an Excel Gantt chart template to make the process a whole lot easier. Let&#8217;s get right to it.<\/p>\n<h2>How do you create a Gantt chart in Excel?<\/h2>\n<p>Well, you can\u2019t (technically). Instead, you\u2019ll have to create a stacked bar chart and embellish it to make it look like a Gantt chart.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/monday.com\/blog\/wp-content\/uploads\/2022\/07\/Gantt_excel_download.xlsx\" rel=\"\">Download Excel template<\/a><\/p>\n<h3>How to create an Excel Gantt chart on a PC<\/h3>\n<p>If you\u2019re using a PC, follow these steps:<\/p>\n<ol>\n<li><strong> Populate an Excel table with your project schedule<\/strong><\/li>\n<\/ol>\n<p>Break down everything by task, and enter them into a column. You can add a start and end date as well as the task duration.<\/p>\n<ol start=\"2\">\n<li><strong> Turn your Excel table into a stacked bar chart<\/strong><\/li>\n<\/ol>\n<p>Select a blank cell, then click the \u201cInsert\u201d tab. From the charts section, choose \u201cStacked Bar\u201d. Don\u2019t pick \u201c100% Stacked Bar\u201d \u2014your Gantt chart will look strange.<\/p>\n<ol start=\"3\">\n<li><strong> Format your stacked bar chart<\/strong><\/li>\n<\/ol>\n<p>Next, you\u2019ll need to reverse task order so your critical path starts with task numero uno. Just select all of your task lists along the vertical access of your Gantt chart, click on the \u201cBar Chart\u201d icon, and choose \u201cFormat axis\u201d. You\u2019ll then see a checkbox called \u201cCategories in reverse order\u201d. Click it.<\/p>\n<p>It can look like this:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-33783\" src=\"https:\/\/www.monday.com\/blog\/wp-content\/uploads\/2020\/12\/image3-29.png\" alt=\"Screenshot of Excel Gantt chart via Microsoft Support\" width=\"816\" height=\"438\" srcset=\"https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/image3-29.png 816w, https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/image3-29-300x161.png 300w, https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/image3-29-768x412.png 768w\" sizes=\"(max-width: 816px) 100vw, 816px\" \/><\/p>\n<p>(<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/present-your-data-in-a-gantt-chart-in-excel-f8910ab4-ceda-4521-8207-f0fb34d9e2b6#OfficeVersion=Windows\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Image source<\/a>)<\/p>\n<p style=\"text-align: center;\"><div class=\"signup-form-wrapper\">\r\n      <div class=\"signup-form-inner\">\r\n      <div class=\"banner \">\r\n         <span class=\"b-left\">\r\n            <div class=\"h2\">One platform for better teamwork <\/div>\r\n            <div class=\"h3\">\r\n              with monday.com Work OS                          <\/div>\r\n              <img decoding=\"async\" class=\"banner-logo d-none d-md-block\" src=\"https:\/\/monday.com\/blog\/wp-content\/themes\/monday\/img\/logo-white.svg\" alt=\"logo\">\r\n         <\/span>\r\n         <span class=\"b-right\">\r\n            <svg class=\"banner-stars d-none d-md-block\" width=\"183\" height=\"85\" viewBox=\"0 0 183 85\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n              <path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M178.536 62.5357L179.322 60L180.109 62.5358L182.645 63.3223L180.109 64.1087L179.322 66.6449L178.536 64.1088L176 63.3223L178.536 62.5357Z\" fill=\"#FBFBFB\"\/>\r\n              <path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M146.776 74.7722L148.566 69L150.357 74.7731L156.129 76.5634L150.357 78.3534L148.566 84.1284L146.775 78.3544L141 76.5634L146.776 74.7722Z\" fill=\"#FBFBFB\"\/>\r\n              <path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M5.77592 5.77216L7.5661 0L9.35658 5.77313L15.1289 7.56336L9.35717 9.35341L7.5661 15.1284L5.77533 9.35438L0.000457764 7.56336L5.77592 5.77216Z\" fill=\"#FBFBFB\"\/>\r\n            <\/svg>\r\n            <svg class=\"banner-stars d-block d-md-none\" width=\"271\" height=\"103\" viewBox=\"0 0 271 103\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n              <path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M266.345 69.806L267.092 67.3984L267.838 69.8059L270.246 70.5527L267.838 71.2994L267.092 73.707L266.345 71.2993L263.937 70.5527L266.345 69.806Z\" fill=\"#FBFBFB\"\/>\r\n              <path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M238.282 93.9891L239.982 88.5078L241.682 93.9899L247.162 95.6895L241.682 97.389L239.982 102.871L238.282 97.3899L232.799 95.6895L238.282 93.9891Z\" fill=\"#FBFBFB\"\/>\r\n              <path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M5.48421 5.67949L7.18416 0.198242L8.88438 5.68035L14.3643 7.37988L8.88419 9.07947L7.18416 14.561L5.4844 9.08033L0.00154114 7.37988L5.48421 5.67949Z\" fill=\"#FBFBFB\"\/>\r\n            <\/svg>\r\n            <a class=\"button-t\" href=\"https:\/\/auth.monday.com\/users\/sign_up_new\" target=\"_blank\">Get started<\/a>\r\n         <\/span>\r\n      <\/div>\r\n      <div class=\"only-mobile\">\r\n        <img decoding=\"async\" class=\"banner-logo\" src=\"https:\/\/monday.com\/blog\/wp-content\/themes\/monday\/img\/logo-white.svg\" alt=\"logo\">\r\n      <\/div>\r\n   <\/div>\r\n<\/div>\r\n<\/p>\n<h3>How to create an Excel Gantt chart on a Mac<\/h3>\n<p>Creating an Excel Gantt chart using a Mac? It\u2019s slightly easier than building a Gantt chart on a PC.<\/p>\n<p>Just follow these steps:<\/p>\n<ol>\n<li><strong> Create your Excel table\u00a0<\/strong><\/li>\n<\/ol>\n<p>Write out a task list and populate it in an Excel table.<\/p>\n<ol start=\"2\">\n<li><strong> Turn your Excel table into a stacked bar chart\u00a0<\/strong><\/li>\n<\/ol>\n<p>Just click \u201cInsert\u201d, \u201cInsert Bar Chart\u201d, and then select \u201cStacked Bar chart\u201d.<\/p>\n<ol start=\"3\">\n<li><strong> Format your Excel Gantt chart<\/strong><\/li>\n<\/ol>\n<p>Click your data series, go to the \u201cFormat\u201d tab, then select \u201cShape Fill\u201d, and \u201cNo Fill\u201d. To get your Gantt chart in reverse task order (so that you\u2019re starting with your first task start dates), hold the control key and select your vertical axis. Then, just hit \u201cFormat Axis\u201d and choose \u201cCategories in reverse order\u201d under the \u201cAxis Position\u201d section.<\/p>\n<p>That\u2019s basically it. But after you\u2019ve finished the basics, you can make little customizations like color coding is (if you prefer blue bars over orange, let&#8217;s say), and save your new Gantt chart as a <a href=\"https:\/\/monday.com\/templates\" target=\"_blank\" rel=\"noopener noreferrer\">template<\/a> for future use.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-33788\" src=\"https:\/\/www.monday.com\/blog\/wp-content\/uploads\/2020\/12\/image2-30.png\" alt=\"Screenshot of Excel Gantt chart showing how chart can be saved as template\" width=\"1074\" height=\"562\" srcset=\"https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/image2-30.png 1074w, https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/image2-30-300x157.png 300w, https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/image2-30-1024x536.png 1024w, https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/image2-30-768x402.png 768w\" sizes=\"(max-width: 1074px) 100vw, 1074px\" \/><\/p>\n<p>(<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/present-your-data-in-a-gantt-chart-in-excel-f8910ab4-ceda-4521-8207-f0fb34d9e2b6#OfficeVersion=MacOS\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Image source<\/a>)<\/p>\n<h3>Is there a Gantt chart template in Excel?<\/h3>\n<p>There is a Gantt chart template in Excel, but only if you\u2019re using a PC. If you work with a Mac, you\u2019re on your own. You can find Microsoft Excel\u2019s Gantt Project Planner template on the Microsoft Office website.<\/p>\n<p>Don&#8217;t use a PC (or just don\u2019t want to manually create a Gantt chart)? Your best bet is going to be creating a Gantt chart on a Work OS like monday.com. It\u2019s super easy. We\u2019ll walk you through it. But before we do, check out our <a href=\"http:\/\/auth.monday.com\/solutions\/add_solution?solution_id=122904\" target=\"_blank\" rel=\"noopener\">free gantt chart templates for excel.<\/a><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><a class=\"cta-button blue-button\" aria-label=\"Get template\" href=\"http:\/\/auth.monday.com\/solutions\/add_solution?solution_id=122904\" target=\"_self\">Get template<\/a><\/p>\n<h2>What\u2019s the easiest way to make a Gantt chart?<\/h2>\n<p>You can create an Excel Gantt chart if you\u2019ve got time to kill. But when time is money, you\u2019re better off creating a Gantt chart using a Work OS (and when it comes to work operating systems, you can\u2019t do better than monday.com).<\/p>\n<p>Want to know how easy it is to<a href=\"https:\/\/support.monday.com\/hc\/en-us\/articles\/360015643840-Gantt-Charts-with-monday-com\" target=\"_blank\" rel=\"noopener noreferrer\"> create your own Gantt chart<\/a>\u00a0on monday.com?<\/p>\n<p>All you have to do is:<\/p>\n<ol>\n<li>Create a board and add your tasks.<\/li>\n<li>Add a &#8220;Task Timeline&#8221; column to your board.<\/li>\n<li>Go to &#8220;Views&#8221; and choose the Timeline or Gantt view.<\/li>\n<\/ol>\n<p>It takes a few minutes, tops. No complicated formatting, no OTT navigation. You can even display percent completed. Plus, you can customize it anyway you want with colors, filters, groups, and more.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-28126 size-full\" title=\"Screenshot of monday.com\" src=\"https:\/\/www.monday.com\/blog\/wp-content\/uploads\/2020\/12\/image1-2.png\" alt=\"Screenshot of monday.com showing Gantt chart view\" width=\"1076\" height=\"672\" srcset=\"https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/image1-2.png 1076w, https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/image1-2-300x187.png 300w, https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/image1-2-1024x640.png 1024w, https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/image1-2-768x480.png 768w\" sizes=\"(max-width: 1076px) 100vw, 1076px\" \/><\/p>\n<p>(<a href=\"https:\/\/monday.com\/solutions\/gantt-chart\" target=\"_blank\" rel=\"noopener noreferrer\">Image source<\/a>)<\/p>\n<p>So, there you have it. If you\u2019re using Excel, you can build a Gantt chart in a few steps on either a Mac or PC. You can even do it in Powerpoint, but that&#8217;s a tale for another day. Microsoft Office has a Gantt chart Excel template that\u2019ll save you time if you\u2019re using a PC.<\/p>\n<p>If you want to save time and have a more dynamic (and prettier) Gantt chart, you\u2019re better off using monday.com Work OS.<\/p>\n<p>So, want to skip the torment of Excel bar charts and improve your project management? <a href=\"https:\/\/monday.monday.com\/create_board_from_template\" target=\"_blank\" rel=\"noopener\">Check out our Gantt chart excel template<\/a>.<\/p>\n<p style=\"text-align: center;\"><a class=\"cta-button blue-button\" aria-label=\"Get template\" href=\"http:\/\/auth.monday.com\/solutions\/add_solution?solution_id=122904\" target=\"_self\">Get template<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Gantt charts are a project manager\u2019s bread and butter. They indicate who\u2019s working on which tasks, dates and durations, crossovers or delays, and everything in between. Gantt charts make life easy for teams trying to get big project plans done. Unfortunately, creating one is challenging without the right Gantt tools &#8230;<\/p>\n","protected":false},"author":5,"featured_media":46496,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_yoast_wpseo_title":"Get Your Excel Gantt Chart Template%%page%% %%sep%% %%sitename%%","_yoast_wpseo_metadesc":"Learn how to make a Gantt chart in Excel for Mac and PC. Then get your own Gantt chart template for a quicker and easier process.","monday_item_id":18059518613,"monday_board_id":0,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[13904],"tags":[13994],"class_list":["post-28114","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-project-management","tag-project-schedule-management"],"acf":{"lobby_image":false,"post_thumbnail_title":"","hide_post_info":false,"hide_bottom_cta":false,"hide_from_blog":false,"cluster":"","banner_url":"https:\/\/auth.monday.com\/users\/sign_up_new#soft_signup_from_step","main_text_banner":"Try monday.com","sub_title_banner":"Easily create a dynamic Gantt chart","sub_title_banner_second":"","banner_button_text":"","below_banner_line":"","display_dates":"updated","custom_schema_code":"","use_customized_cta":false,"display_subscribe_widget":false,"post_date":"20220327","landing_page_layout":false,"featured_image_link":"","sidebar_color_banner":"","custom_tags":[13994],"faqs":false,"activate_cta_banner":false,"hide_time_to_read":false,"disclaimer":"","cornerstone_hero_cta_override":{"label":"","url":""}},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.6 (Yoast SEO v26.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Get Your Excel Gantt Chart Template | monday.com Blog<\/title>\n<meta name=\"description\" content=\"Learn how to make a Gantt chart in Excel for Mac and PC. Then get your own Gantt chart template for a quicker and easier process.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Making Gantt charts in Excel [free Excel Gantt chart template]\" \/>\n<meta property=\"og:description\" content=\"Learn how to make a Gantt chart in Excel for Mac and PC. Then get your own Gantt chart template for a quicker and easier process.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"monday.com Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-25T14:55:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-07T11:12:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/res.cloudinary.com\/monday-blogs\/fl_lossy,f_auto,q_auto\/wp-blog\/2021\/01\/Gantt-chart-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2402\" \/>\n\t<meta property=\"og:image:height\" content=\"1201\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"monday.com\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"monday.com\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/\"},\"author\":{\"name\":\"monday.com\",\"@id\":\"https:\/\/monday.com\/blog\/#\/schema\/person\/002eeffbafc08d763cb24e64dd45cae4\"},\"headline\":\"Making Gantt charts in Excel [free Excel Gantt chart template]\",\"datePublished\":\"2021-01-25T14:55:36+00:00\",\"dateModified\":\"2024-07-07T11:12:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/\"},\"wordCount\":926,\"publisher\":{\"@id\":\"https:\/\/monday.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/monday.com\/blog\/wp-content\/uploads\/2021\/01\/Gantt-chart-1.jpg\",\"keywords\":[\"Project schedule management\"],\"articleSection\":[\"Project management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/\",\"url\":\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/\",\"name\":\"Get Your Excel Gantt Chart Template | monday.com Blog\",\"isPartOf\":{\"@id\":\"https:\/\/monday.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/monday.com\/blog\/wp-content\/uploads\/2021\/01\/Gantt-chart-1.jpg\",\"datePublished\":\"2021-01-25T14:55:36+00:00\",\"dateModified\":\"2024-07-07T11:12:55+00:00\",\"description\":\"Learn how to make a Gantt chart in Excel for Mac and PC. Then get your own Gantt chart template for a quicker and easier process.\",\"breadcrumb\":{\"@id\":\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#primaryimage\",\"url\":\"https:\/\/monday.com\/blog\/wp-content\/uploads\/2021\/01\/Gantt-chart-1.jpg\",\"contentUrl\":\"https:\/\/monday.com\/blog\/wp-content\/uploads\/2021\/01\/Gantt-chart-1.jpg\",\"width\":2402,\"height\":1201,\"caption\":\"Making Gantt charts in Excel free Excel Gantt chart template\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/monday.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Project management\",\"item\":\"https:\/\/monday.com\/blog\/project-management\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Making Gantt charts in Excel [free Excel Gantt chart template]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/monday.com\/blog\/#website\",\"url\":\"https:\/\/monday.com\/blog\/\",\"name\":\"monday.com Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/monday.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/monday.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/monday.com\/blog\/#organization\",\"name\":\"monday.com Blog\",\"url\":\"https:\/\/monday.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monday.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/res.cloudinary.com\/monday-blogs\/fl_lossy,f_auto,q_auto\/wp-blog\/2020\/12\/monday.com-logo-1.png\",\"contentUrl\":\"https:\/\/res.cloudinary.com\/monday-blogs\/fl_lossy,f_auto,q_auto\/wp-blog\/2020\/12\/monday.com-logo-1.png\",\"width\":200,\"height\":200,\"caption\":\"monday.com Blog\"},\"image\":{\"@id\":\"https:\/\/monday.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/monday.com\/blog\/#\/schema\/person\/002eeffbafc08d763cb24e64dd45cae4\",\"name\":\"monday.com\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/monday.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/monday.com-logo-1-150x150.png\",\"contentUrl\":\"https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/monday.com-logo-1-150x150.png\",\"caption\":\"monday.com\"},\"url\":\"https:\/\/monday.com\/blog\/author\/the-monday-com-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Get Your Excel Gantt Chart Template | monday.com Blog","description":"Learn how to make a Gantt chart in Excel for Mac and PC. Then get your own Gantt chart template for a quicker and easier process.","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:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Making Gantt charts in Excel [free Excel Gantt chart template]","og_description":"Learn how to make a Gantt chart in Excel for Mac and PC. Then get your own Gantt chart template for a quicker and easier process.","og_url":"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/","og_site_name":"monday.com Blog","article_published_time":"2021-01-25T14:55:36+00:00","article_modified_time":"2024-07-07T11:12:55+00:00","og_image":[{"width":2402,"height":1201,"url":"https:\/\/res.cloudinary.com\/monday-blogs\/fl_lossy,f_auto,q_auto\/wp-blog\/2021\/01\/Gantt-chart-1.jpg","type":"image\/jpeg"}],"author":"monday.com","twitter_card":"summary_large_image","twitter_misc":{"Written by":"monday.com","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#article","isPartOf":{"@id":"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/"},"author":{"name":"monday.com","@id":"https:\/\/monday.com\/blog\/#\/schema\/person\/002eeffbafc08d763cb24e64dd45cae4"},"headline":"Making Gantt charts in Excel [free Excel Gantt chart template]","datePublished":"2021-01-25T14:55:36+00:00","dateModified":"2024-07-07T11:12:55+00:00","mainEntityOfPage":{"@id":"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/"},"wordCount":926,"publisher":{"@id":"https:\/\/monday.com\/blog\/#organization"},"image":{"@id":"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/monday.com\/blog\/wp-content\/uploads\/2021\/01\/Gantt-chart-1.jpg","keywords":["Project schedule management"],"articleSection":["Project management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/","url":"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/","name":"Get Your Excel Gantt Chart Template | monday.com Blog","isPartOf":{"@id":"https:\/\/monday.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/monday.com\/blog\/wp-content\/uploads\/2021\/01\/Gantt-chart-1.jpg","datePublished":"2021-01-25T14:55:36+00:00","dateModified":"2024-07-07T11:12:55+00:00","description":"Learn how to make a Gantt chart in Excel for Mac and PC. Then get your own Gantt chart template for a quicker and easier process.","breadcrumb":{"@id":"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#primaryimage","url":"https:\/\/monday.com\/blog\/wp-content\/uploads\/2021\/01\/Gantt-chart-1.jpg","contentUrl":"https:\/\/monday.com\/blog\/wp-content\/uploads\/2021\/01\/Gantt-chart-1.jpg","width":2402,"height":1201,"caption":"Making Gantt charts in Excel free Excel Gantt chart template"},{"@type":"BreadcrumbList","@id":"https:\/\/monday.com\/blog\/project-management\/gantt-chart-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/monday.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Project management","item":"https:\/\/monday.com\/blog\/project-management\/"},{"@type":"ListItem","position":3,"name":"Making Gantt charts in Excel [free Excel Gantt chart template]"}]},{"@type":"WebSite","@id":"https:\/\/monday.com\/blog\/#website","url":"https:\/\/monday.com\/blog\/","name":"monday.com Blog","description":"","publisher":{"@id":"https:\/\/monday.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/monday.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/monday.com\/blog\/#organization","name":"monday.com Blog","url":"https:\/\/monday.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monday.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/res.cloudinary.com\/monday-blogs\/fl_lossy,f_auto,q_auto\/wp-blog\/2020\/12\/monday.com-logo-1.png","contentUrl":"https:\/\/res.cloudinary.com\/monday-blogs\/fl_lossy,f_auto,q_auto\/wp-blog\/2020\/12\/monday.com-logo-1.png","width":200,"height":200,"caption":"monday.com Blog"},"image":{"@id":"https:\/\/monday.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/monday.com\/blog\/#\/schema\/person\/002eeffbafc08d763cb24e64dd45cae4","name":"monday.com","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/monday.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/monday.com-logo-1-150x150.png","contentUrl":"https:\/\/monday.com\/blog\/wp-content\/uploads\/2020\/12\/monday.com-logo-1-150x150.png","caption":"monday.com"},"url":"https:\/\/monday.com\/blog\/author\/the-monday-com-team\/"}]}},"auth_debug":{"user_exists":false,"user_id":0,"user_login":null,"roles":[],"authenticated":false,"get_current_user_id":0},"_links":{"self":[{"href":"https:\/\/monday.com\/blog\/wp-json\/wp\/v2\/posts\/28114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/monday.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/monday.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/monday.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/monday.com\/blog\/wp-json\/wp\/v2\/comments?post=28114"}],"version-history":[{"count":24,"href":"https:\/\/monday.com\/blog\/wp-json\/wp\/v2\/posts\/28114\/revisions"}],"predecessor-version":[{"id":227342,"href":"https:\/\/monday.com\/blog\/wp-json\/wp\/v2\/posts\/28114\/revisions\/227342"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/monday.com\/blog\/wp-json\/wp\/v2\/media\/46496"}],"wp:attachment":[{"href":"https:\/\/monday.com\/blog\/wp-json\/wp\/v2\/media?parent=28114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/monday.com\/blog\/wp-json\/wp\/v2\/categories?post=28114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/monday.com\/blog\/wp-json\/wp\/v2\/tags?post=28114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}