{"id":23349,"date":"2023-08-07T14:43:00","date_gmt":"2023-08-07T14:43:00","guid":{"rendered":"https:\/\/toggl.com\/blog\/?p=23349"},"modified":"2024-06-15T07:41:21","modified_gmt":"2024-06-15T07:41:21","slug":"gantt-chart-excel","status":"publish","type":"post","link":"https:\/\/toggl.com\/blog\/gantt-chart-excel","title":{"rendered":"How To Make A Gantt Chart In Excel (+ Free Templates)"},"content":{"rendered":"\n<p>Although it comes with limitations, creating a Gantt Chart in Excel is still the go-to charting method for many professionals.<\/p>\n\n\n\n<p>It isn\u2019t easy and quick (as you\u2019ll see next). And the charts aren\u2019t great looking.<\/p>\n\n\n\n<p>But even though Excel doesn\u2019t create the prettiest charts, it helps you get the job done.<\/p>\n\n\n\n<p>If you\u2019re interested in functionality rather than the look of your <a href=\"https:\/\/toggl.com\/blog\/what-is-a-gantt-chart\">Gantt Charts<\/a>, read on to learn how to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Make a Gantt chart in Excel in eight steps<\/li>\n\n\n\n<li>Style your Excel Gantt chart<\/li>\n\n\n\n<li>Use Excel Gantt chart templates<\/li>\n<\/ul>\n\n\n\n<p>Let\u2019s get into it!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to Make a Gantt Chart in Excel: Step-by-Step Guide<\/h2>\n\n\n\n<p>It takes eight steps to make a Gantt chart in Excel. Ready? Let\u2019s dive in.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Create a project data table<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Create a new Excel spreadsheet.<\/li>\n\n\n\n<li><strong>Add the columns<\/strong> for your project tasks. Each task should be defined with a <strong>task name, start date, and duration<\/strong> (the number of hours, days, weeks, or months it\u2019s going to last).<\/li>\n<\/ol>\n\n\n\n<p>Here\u2019s a sample worksheet for a simple construction project:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"639\" height=\"517\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/1.png\" alt=\"\" class=\"wp-image-45237\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/1.png 639w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/1-300x243.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/1-499x404.png 499w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/1-112x91.png 112w\" sizes=\"auto, (max-width: 639px) 100vw, 639px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Set up a stacked bar chart<\/h3>\n\n\n\n<p>Excel does not come with an inbuilt Gantt chart template.<\/p>\n\n\n\n<p>Instead, we\u2019ll create one using a stacked bar chart.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select your task information. Next, click on <strong>Insert<\/strong> tab <strong>&gt; Bar Chart &gt;<\/strong> <strong>Stacked Bar Chart<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"893\" height=\"516\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/2.png\" alt=\"\" class=\"wp-image-45238\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/2.png 893w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/2-300x173.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/2-699x404.png 699w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/2-112x65.png 112w\" sizes=\"auto, (max-width: 893px) 100vw, 893px\" \/><\/figure>\n\n\n\n<p>The new chart will be a block of white space, like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"885\" height=\"364\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/3.png\" alt=\"\" class=\"wp-image-45239\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/3.png 885w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/3-300x123.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/3-746x307.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/3-112x46.png 112w\" sizes=\"auto, (max-width: 885px) 100vw, 885px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Add start dates to the chart<\/h3>\n\n\n\n<p>Let\u2019s populate the chart with our task data. To do that, <strong>right-click on the chart<\/strong>. Then <strong>click Select Data<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"973\" height=\"768\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/4.png\" alt=\"\" class=\"wp-image-45240\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/4.png 973w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/4-300x237.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/4-512x404.png 512w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/4-963x760.png 963w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/4-112x88.png 112w\" sizes=\"auto, (max-width: 973px) 100vw, 973px\" \/><\/figure>\n\n\n\n<p>2. This opens the Select Data Source dialog. Here, we\u2019ll <strong>set the Legend Entries to task start dates and durations<\/strong>.<\/p>\n\n\n\n<p><strong>Click on the plus button<\/strong> in the Legend entries (series) section to add the range of start dates first.<\/p>\n\n\n\n\n\n<p>3. Set the Series name to \u201cStart Date\u201d.<\/p>\n\n\n\n<p>To do that, <strong>click on the empty field<\/strong> next to <strong>Name<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"647\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6-1024x647.png\" alt=\"\" class=\"wp-image-45268\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6-1024x647.png 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6-300x190.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6-1536x970.png 1536w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6-639x404.png 639w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6-1152x728.png 1152w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6-1276x806.png 1276w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6-112x71.png 112w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6.png 1950w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Note<\/strong>: If you select the cell with the title and then change it later on, the Series name will change along with it.<\/p>\n\n\n\n<p>But, if you type up the name and then later change the title of the column in the spreadsheet, the name will remain the same.<\/p>\n\n\n\n<p>4. Set the Series values to the cell range that contains the task start dates.<\/p>\n\n\n\n<p>In the <strong>Edit Series window<\/strong>, to the right of the Series values, <strong>click on<\/strong> the arrow pointing up and a smaller Edit Series window will appear. <strong>Click on<\/strong> the first start date in your table and <strong>drag your cursor down<\/strong> to the last start date. <strong>Click on the arrow<\/strong> again to return to the previous <strong>Edit Series<\/strong> window and <strong>click OK<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"839\" height=\"350\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6-1.png\" alt=\"\" class=\"wp-image-45269\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6-1.png 839w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6-1-300x125.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6-1-746x311.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/6-1-112x47.png 112w\" sizes=\"auto, (max-width: 839px) 100vw, 839px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4: Add duration data to the chart<\/h3>\n\n\n\n<p>1. After adding your start dates, it\u2019s time to add duration data. To do this, <strong>click on the Add button<\/strong> in the Select Data Source screen.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"929\" height=\"358\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/7.png\" alt=\"\" class=\"wp-image-45270\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/7.png 929w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/7-300x116.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/7-746x287.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/7-112x43.png 112w\" sizes=\"auto, (max-width: 929px) 100vw, 929px\" \/><\/figure>\n\n\n\n<p>2. Set the Series name to \u201cDuration\u201d. The same as the third section of the previous step.<\/p>\n\n\n\n<p>Set the Series values to the cell range that contains the task durations. The same as the fourth section of the previous step.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"838\" height=\"352\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/8.png\" alt=\"\" class=\"wp-image-45271\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/8.png 838w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/8-300x126.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/8-746x313.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/8-112x47.png 112w\" sizes=\"auto, (max-width: 838px) 100vw, 838px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 5: Add task descriptions to the chart<\/h3>\n\n\n\n<p>1. Next, we want to <strong>add the task descriptions (names)<\/strong> <strong>to the vertical axis<\/strong>. This is done by editing the horizontal (Category) axis labels.<br>In the Select Data Source window, <strong>click on the Edit button<\/strong> to add task names to the horizontal (Category) axis labels.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"860\" height=\"436\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/9.png\" alt=\"\" class=\"wp-image-45272\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/9.png 860w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/9-300x152.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/9-746x378.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/9-112x57.png 112w\" sizes=\"auto, (max-width: 860px) 100vw, 860px\" \/><\/figure>\n\n\n\n<p>2. Here, simply <strong>click on<\/strong> <strong>the first task<\/strong> in your table and <strong>drag your cursor down to the last task<\/strong>. (notice how the Axis label range field will be automatically filled).<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"846\" height=\"358\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/10.png\" alt=\"\" class=\"wp-image-45273\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/10.png 846w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/10-300x127.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/10-746x316.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/10-112x47.png 112w\" sizes=\"auto, (max-width: 846px) 100vw, 846px\" \/><\/figure>\n\n\n\n<p>3. Bonus: In case a chart label block shows up on your chart and you don\u2019t want to have it there, <strong>right-click<\/strong> on it and <strong>select Delete<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"986\" height=\"431\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/11.png\" alt=\"\" class=\"wp-image-45274\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/11.png 986w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/11-300x131.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/11-746x326.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/11-112x49.png 112w\" sizes=\"auto, (max-width: 986px) 100vw, 986px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 6: Transform the bar chart into an Excel Gantt chart<\/h3>\n\n\n\n<p>The stacked bar is ready. Your tasks are laid out on the chart as orange and blue bars.<\/p>\n\n\n\n<p>But, it doesn\u2019t look like a Gantt chart.<\/p>\n\n\n\n<p>Let\u2019s format it to look like one.<\/p>\n\n\n\n<p>1. <strong>Right-click on the blue part of the bar<\/strong>. Then <strong>click on Format Data Series\u2026<\/strong> to open the Formatting dialog.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/12.png\" alt=\"\" class=\"wp-image-45275\" width=\"840\" height=\"418\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/12.png 846w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/12-300x149.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/12-746x371.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/12-112x56.png 112w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><\/figure>\n\n\n\n<p>2. In the dialog, set the Fill option to <strong>No fill<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"363\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/13-1024x363.png\" alt=\"\" class=\"wp-image-45276\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/13-1024x363.png 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/13-300x106.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/13-746x264.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/13-1152x408.png 1152w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/13-112x40.png 112w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/13.png 1357w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Now our chart looks a bit more like a Gantt chart.<\/p>\n\n\n\n<p>But it still has a couple of issues:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The tasks on the vertical axis are in reverse order.<\/li>\n\n\n\n<li>The start date range on the horizontal axis is too wide.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 7: Fix the task order<\/h3>\n\n\n\n<p>1. To fix the issue of the reverse task order, <strong>right-click on the vertical axis<\/strong>.<\/p>\n\n\n\n<p>2. Then <strong>click on the Format Axis\u2026<\/strong> context menu to open the Format Axis dialog.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1018\" height=\"478\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/14.png\" alt=\"\" class=\"wp-image-45277\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/14.png 1018w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/14-300x141.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/14-746x350.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/14-112x53.png 112w\" sizes=\"auto, (max-width: 1018px) 100vw, 1018px\" \/><\/figure>\n\n\n\n<p>3. In this dialog, <strong>check Axis Options &gt; Categories in reverse order<\/strong>. The tasks should now appear in the right order.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"364\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/15-1024x364.png\" alt=\"\" class=\"wp-image-45278\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/15-1024x364.png 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/15-300x107.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/15-746x265.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/15-1152x410.png 1152w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/15-112x40.png 112w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/15.png 1325w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 8: Remove the empty space at the left-hand side of the Gantt chart<\/h3>\n\n\n\n<p>Next, let\u2019s remove the white space on the left-hand side to bring our tasks closer to the vertical axis.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"462\" height=\"433\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/16.png\" alt=\"\" class=\"wp-image-45279\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/16.png 462w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/16-300x281.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/16-431x404.png 431w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/16-112x105.png 112w\" sizes=\"auto, (max-width: 462px) 100vw, 462px\" \/><\/figure>\n\n\n\n<p>1. <strong>Select the first Start Date<\/strong> in your data table, then drop down the Number Formats list (under the Home Tab).<\/p>\n\n\n\n<p><strong>See the number shown in the Number option<\/strong> (in this case 45176), and write it down for the next step.<\/p>\n\n\n\n<p><strong>Click on<\/strong> any cell in the sheet again to close this window as you don\u2019t want to make any changes here.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/17.png\" alt=\"\" class=\"wp-image-45280\" width=\"792\" height=\"620\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/17.png 792w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/17-300x235.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/17-516x404.png 516w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/17-112x88.png 112w\" sizes=\"auto, (max-width: 792px) 100vw, 792px\" \/><\/figure>\n\n\n\n<p>2.<strong> Right-click on any date<\/strong> above the task bars on your chart and <strong>open the Format Axis dialog box<\/strong>.<\/p>\n\n\n\n<p>3. Set <strong>Axis Options &gt; Minimum Bound<\/strong> to the number you wrote down in the first step.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"370\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/18-1024x370.png\" alt=\"\" class=\"wp-image-45282\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/18-1024x370.png 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/18-300x108.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/18-746x270.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/18-1152x416.png 1152w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/18-112x40.png 112w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/18.png 1361w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>With that done, your Excel Gantt chart is ready, showing each task and its start and end date. Any changes you make to the data will also reflect automatically in the chart.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"350\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/19-1024x350.png\" alt=\"\" class=\"wp-image-45283\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/19-1024x350.png 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/19-300x103.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/19-746x255.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/19-1152x394.png 1152w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/19-112x38.png 112w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/19.png 1272w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Bonus: Remove the empty space at the right-hand side of the Gantt chart<\/h3>\n\n\n\n<p>Now, your Excel Gantt chart will not be good-looking.<\/p>\n\n\n\n<p>But don\u2019t let that discourage you.<\/p>\n\n\n\n<p>Polish things up by removing white spaces to prettify your chart. Here\u2019s how to do it:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"924\" height=\"404\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/20.png\" alt=\"\" class=\"wp-image-45284\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/20.png 924w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/20-300x131.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/20-746x326.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/20-112x49.png 112w\" sizes=\"auto, (max-width: 924px) 100vw, 924px\" \/><\/figure>\n\n\n\n<p>1. First, <strong>click on the last date<\/strong> in your list and check its number as we did in Step 8. Then, <strong>add this number in the duration column<\/strong>, in this case 4.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"535\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/21.png\" alt=\"\" class=\"wp-image-45285\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/21.png 800w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/21-300x201.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/21-604x404.png 604w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/21-112x75.png 112w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<p>2. <strong>Right-click on any date<\/strong> above the task bars on your chart and <strong>open the Format Axis dialog box<\/strong>.<\/p>\n\n\n\n<p>Set <strong>Axis Options &gt; Maximum Bound<\/strong> to the number you got by adding 4 to the last start date number.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"955\" height=\"494\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/22.png\" alt=\"\" class=\"wp-image-45286\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/22.png 955w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/22-300x155.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/22-746x386.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/22-112x58.png 112w\" sizes=\"auto, (max-width: 955px) 100vw, 955px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Excel Gantt Chart Styling Tips<\/h2>\n\n\n\n<p>Continue with the chart\u2019s makeover to give it some edge.<\/p>\n\n\n\n<p>Here are some tips:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Adjust the number and density of the dates on the chart<\/h3>\n\n\n\n<p>1. To do this, <strong>Right-click on any date<\/strong> above the task bars on your chart and <strong>open the Format Axis dialog box<\/strong>.<\/p>\n\n\n\n<p>2. Then, in the <strong>Axis Options window, increase the Major unit number<\/strong> to create more space between each date or <strong>decrease<\/strong> it to reduce the space between each date.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"385\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/23-1024x385.png\" alt=\"\" class=\"wp-image-45287\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/23-1024x385.png 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/23-300x113.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/23-746x280.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/23-1152x433.png 1152w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/23-112x42.png 112w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/23.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Remove excess white space between the bars<\/h2>\n\n\n\n<p>1. Select your bars by <strong>clicking on<\/strong> any of them, then <strong>right-click<\/strong> and select Format Data Series.<\/p>\n\n\n\n<p>2. In the <strong>Format Data Series<\/strong> window that pops up, set the <strong>Series Overlap<\/strong> to 100% and the <strong>Gap Width<\/strong> to <strong>0%<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"346\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/24-1024x346.png\" alt=\"\" class=\"wp-image-45288\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/24-1024x346.png 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/24-300x101.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/24-746x252.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/24-1152x389.png 1152w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/24-112x38.png 112w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/24.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Play with the chart design<\/h3>\n\n\n\n<p><strong>Select<\/strong> the chart area, then click on <strong>Chart Design<\/strong>, then click on <strong>Add Chart Element &gt; Chart Title &gt; Above Chart<\/strong>.<\/p>\n\n\n\n<p>In the <strong>Format Chart Title<\/strong> window, click on <strong>Title Options<\/strong> &gt; <strong>Text Fill<\/strong> and select <strong>Solid fill<\/strong>. Then, select the color by <strong>clicking on the arrow pointing down<\/strong> next to the <strong>Color<\/strong> text.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"471\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/25-1024x471.png\" alt=\"\" class=\"wp-image-45289\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/25-1024x471.png 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/25-300x138.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/25-746x343.png 746w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/25-1152x530.png 1152w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/25-112x51.png 112w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/25.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>And that\u2019s pretty much it. You now know how to <a href=\"https:\/\/toggl.com\/blog\/create-a-gantt-chart\">create a Gantt chart<\/a> in Excel.<\/p>\n\n\n\n<p>In case that\u2019s too much work for you (we believe it might be) you can take the shortcut and use Excel <a href=\"https:\/\/toggl.com\/blog\/how-to-create-a-free-gantt-chart-template\">Gantt chart templates<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel Gantt Chart Template Options<\/h2>\n\n\n\n<p>Microsoft Office comes with free and premium <a href=\"https:\/\/toggl.com\/blog\/project-timeline-templates\">project timeline templates<\/a> for making Excel Gantt charts.<\/p>\n\n\n\n<p>Here are some you may find useful.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/create.microsoft.com\/en-us\/template\/simple-gantt-chart-4bf6b793-490f-4623-84ca-c9c6251a91fc\" target=\"_blank\">Simple Gantt Chart Template<\/a>: This is a free template that you can download from the official MS Office Templates website. However, this template does not have any options to add milestones.<\/li>\n\n\n\n<li><a href=\"https:\/\/create.microsoft.com\/en-us\/template\/agile-gantt-chart-c29ed7ae-85bf-4494-9a46-cf50fab44efa\" target=\"_blank\">Agile Gantt Chart Template<\/a>: A fully customizable, free template that agile teams can use to visualize their projects, track their tasks, and improve their workflows.<\/li>\n\n\n\n<li><a href=\"https:\/\/create.microsoft.com\/en-us\/template\/date-tracking-gantt-chart-2e0e1db9-2cf2-4a79-8d66-5eb725dc1d31\" target=\"_blank\">Date Tracking Gantt Chart Template<\/a>: This is a free template that allows you to simply track dates and milestones. Download it from the official MS Office Templates website.<\/li>\n<\/ul>\n\n\n\n<p>Using these templates, you can somewhat simplify the process of creating a Gantt chart in Excel.<\/p>\n\n\n\n<p>However, Excel templates come with certain limitations that only a more complex <a href=\"https:\/\/toggl.com\/blog\/mac-gantt-chart-software\">Gantt chart software<\/a> tool can overcome.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel Gantt Chart Alternative<\/h2>\n\n\n\n<p>As you&#8217;ve seen, creating a Gantt chart in Excel is quite a task. And, it makes it almost impossible to collaborate with stakeholders and team members.<\/p>\n\n\n\n<p>Plus, it\u2019s hard to keep the Excel sheet up-to-date.<\/p>\n\n\n\n<p>That\u2019s where <a href=\"https:\/\/toggl.com\/plan\/index\">Toggl Plan<\/a> can help.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"640\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/monthly-timeline-1024x640.png\" alt=\"\" class=\"wp-image-45290\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/monthly-timeline-1024x640.png 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/monthly-timeline-300x188.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/monthly-timeline-1536x960.png 1536w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/monthly-timeline-2048x1280.png 2048w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/monthly-timeline-646x404.png 646w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/monthly-timeline-1152x720.png 1152w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/monthly-timeline-1290x806.png 1290w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2023\/08\/monthly-timeline-112x70.png 112w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>With Toggl Plan, you can:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create a Gantt chart timeline to <a href=\"https:\/\/toggl.com\/blog\/starter-guide-project-planning\">plan and track<\/a> a project\u2019s schedule.<\/li>\n\n\n\n<li>Create a team timeline to manage resource availability and workloads.<\/li>\n\n\n\n<li>Add project milestones to manage <a href=\"https:\/\/toggl.com\/blog\/project-risks\">project risk<\/a> better.<\/li>\n\n\n\n<li>Collaborate with stakeholders. Add them to a timeline or share a read-only view.<\/li>\n\n\n\n<li>Assign tasks to multiple team members and track progress as they complete work.<\/li>\n<\/ul>\n\n\n\n<p>Toggl Plan\u2019s Gantt charts are easy to use. You can just click to add tasks on the timeline and move them around with a simple drag-and-drop.<\/p>\n\n\n\n<p>Best of all, Toggl Plan is <strong>completely free for solo users<\/strong>. Teams can try our <strong>14-day free trial<\/strong>. Paid plans are very affordable, starting at $9\/user\/month.<\/p>\n\n\n\n<p><a href=\"https:\/\/toggl.com\/plan\/pricing\">Try out Toggl Plan for free.<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Frequently Asked Questions (FAQs)<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">What is a Gantt chart?<\/h3>\n\n\n\n<p>A Gantt chart is a visual representation of a project schedule and tasks. A Gantt chart provides a timeline view of project activities, with the start and finish dates of each task.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Is there a Gantt chart template in Excel?<\/h3>\n\n\n\n<p>Although Excel doesn\u2019t have built-in Gantt chart templates, there are multiple free or paid templates that you can download from the official MS Office Templates website.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Are Gantt charts better than PERT charts?<\/h3>\n\n\n\n<p>Both Gantt charts and PERT charts are useful tools in project management, helping with project visualization and planning. However, they can serve different purposes and have distinct advantages, so it all comes down to the specific needs of each project.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Although it comes with limitations, creating a Gantt Chart in Excel is still the go-to charting method for many professionals. It isn\u2019t easy and quick&#8230;<\/p>\n","protected":false},"author":607,"featured_media":23374,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[851],"tags":[],"class_list":["post-23349","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 Excel (+ Free Templates)<\/title>\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-excel\" \/>\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 Excel (+ Free Templates)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/toggl.com\/blog\/gantt-chart-excel\" \/>\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=\"2023-08-07T14:43:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-15T07:41:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/how-to-make-a-gantt-chart-in-excel.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=\"Jitesh Patil\" \/>\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=\"Jitesh Patil\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 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-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-excel\"},\"author\":{\"name\":\"Jitesh Patil\",\"@id\":\"https:\/\/toggl.com\/blog\/#\/schema\/person\/1f14ae0cadc59db374eaaf4c8de016e6\"},\"headline\":\"How To Make A Gantt Chart In Excel (+ Free Templates)\",\"datePublished\":\"2023-08-07T14:43:00+00:00\",\"dateModified\":\"2024-06-15T07:41:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-excel\"},\"wordCount\":1731,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/toggl.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/how-to-make-a-gantt-chart-in-excel.jpg\",\"articleSection\":[\"Project Management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-excel\",\"url\":\"https:\/\/toggl.com\/blog\/gantt-chart-excel\",\"name\":\"How To Make A Gantt Chart In Excel (+ Free Templates)\",\"isPartOf\":{\"@id\":\"https:\/\/toggl.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-excel#primaryimage\"},\"image\":{\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/how-to-make-a-gantt-chart-in-excel.jpg\",\"datePublished\":\"2023-08-07T14:43:00+00:00\",\"dateModified\":\"2024-06-15T07:41:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/toggl.com\/blog\/gantt-chart-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-excel#primaryimage\",\"url\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/how-to-make-a-gantt-chart-in-excel.jpg\",\"contentUrl\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/how-to-make-a-gantt-chart-in-excel.jpg\",\"width\":1200,\"height\":719,\"caption\":\"How to make a Gantt chart in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/toggl.com\/blog\/gantt-chart-excel#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 Excel (+ 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\/1f14ae0cadc59db374eaaf4c8de016e6\",\"name\":\"Jitesh Patil\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/18c6b101c496f4ed723c0e9716f9344068d223a5ae60030e45f79cfc521e7477?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18c6b101c496f4ed723c0e9716f9344068d223a5ae60030e45f79cfc521e7477?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18c6b101c496f4ed723c0e9716f9344068d223a5ae60030e45f79cfc521e7477?s=96&d=mm&r=g\",\"caption\":\"Jitesh Patil\"},\"description\":\"Jitesh is an SEO and content specialist. He manages content projects at Toggl and loves sharing actionable tips to deliver projects profitably.\",\"sameAs\":[\"https:\/\/toggl.com\",\"https:\/\/www.linkedin.com\/in\/jiteshpatil\/\"],\"url\":\"https:\/\/toggl.com\/blog\/author\/jitesh-patil\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Make A Gantt Chart In Excel (+ Free Templates)","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-excel","og_locale":"en_US","og_type":"article","og_title":"How To Make A Gantt Chart In Excel (+ Free Templates)","og_url":"https:\/\/toggl.com\/blog\/gantt-chart-excel","og_site_name":"Toggl Blog","article_publisher":"https:\/\/www.facebook.com\/Toggl\/","article_published_time":"2023-08-07T14:43:00+00:00","article_modified_time":"2024-06-15T07:41:21+00:00","og_image":[{"width":1200,"height":719,"url":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/how-to-make-a-gantt-chart-in-excel.jpg","type":"image\/jpeg"}],"author":"Jitesh Patil","twitter_card":"summary_large_image","twitter_creator":"@toggl","twitter_site":"@toggl","twitter_misc":{"Written by":"Jitesh Patil","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/toggl.com\/blog\/gantt-chart-excel#article","isPartOf":{"@id":"https:\/\/toggl.com\/blog\/gantt-chart-excel"},"author":{"name":"Jitesh Patil","@id":"https:\/\/toggl.com\/blog\/#\/schema\/person\/1f14ae0cadc59db374eaaf4c8de016e6"},"headline":"How To Make A Gantt Chart In Excel (+ Free Templates)","datePublished":"2023-08-07T14:43:00+00:00","dateModified":"2024-06-15T07:41:21+00:00","mainEntityOfPage":{"@id":"https:\/\/toggl.com\/blog\/gantt-chart-excel"},"wordCount":1731,"commentCount":0,"publisher":{"@id":"https:\/\/toggl.com\/blog\/#organization"},"image":{"@id":"https:\/\/toggl.com\/blog\/gantt-chart-excel#primaryimage"},"thumbnailUrl":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/how-to-make-a-gantt-chart-in-excel.jpg","articleSection":["Project Management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/toggl.com\/blog\/gantt-chart-excel","url":"https:\/\/toggl.com\/blog\/gantt-chart-excel","name":"How To Make A Gantt Chart In Excel (+ Free Templates)","isPartOf":{"@id":"https:\/\/toggl.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/toggl.com\/blog\/gantt-chart-excel#primaryimage"},"image":{"@id":"https:\/\/toggl.com\/blog\/gantt-chart-excel#primaryimage"},"thumbnailUrl":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/how-to-make-a-gantt-chart-in-excel.jpg","datePublished":"2023-08-07T14:43:00+00:00","dateModified":"2024-06-15T07:41:21+00:00","breadcrumb":{"@id":"https:\/\/toggl.com\/blog\/gantt-chart-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/toggl.com\/blog\/gantt-chart-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/toggl.com\/blog\/gantt-chart-excel#primaryimage","url":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/how-to-make-a-gantt-chart-in-excel.jpg","contentUrl":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/09\/how-to-make-a-gantt-chart-in-excel.jpg","width":1200,"height":719,"caption":"How to make a Gantt chart in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/toggl.com\/blog\/gantt-chart-excel#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 Excel (+ 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\/1f14ae0cadc59db374eaaf4c8de016e6","name":"Jitesh Patil","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/18c6b101c496f4ed723c0e9716f9344068d223a5ae60030e45f79cfc521e7477?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/18c6b101c496f4ed723c0e9716f9344068d223a5ae60030e45f79cfc521e7477?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18c6b101c496f4ed723c0e9716f9344068d223a5ae60030e45f79cfc521e7477?s=96&d=mm&r=g","caption":"Jitesh Patil"},"description":"Jitesh is an SEO and content specialist. He manages content projects at Toggl and loves sharing actionable tips to deliver projects profitably.","sameAs":["https:\/\/toggl.com","https:\/\/www.linkedin.com\/in\/jiteshpatil\/"],"url":"https:\/\/toggl.com\/blog\/author\/jitesh-patil"}]}},"_links":{"self":[{"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/posts\/23349","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\/607"}],"replies":[{"embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/comments?post=23349"}],"version-history":[{"count":33,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/posts\/23349\/revisions"}],"predecessor-version":[{"id":45868,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/posts\/23349\/revisions\/45868"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/media\/23374"}],"wp:attachment":[{"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/media?parent=23349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/categories?post=23349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/tags?post=23349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}