CINXE.COM

<!DOCTYPE html><html lang="en"><head><meta charset="utf-8"><meta name="viewport" content="width=device-width, initial-scale=1.0"><link rel="preconnect" href="//www.zohowebstatic.com"><link rel="dns-prefetch" href="//www.zohowebstatic.com"><link rel="preconnect" href="https://static.zohocdn.com"><link rel="dns-prefetch" href="https://static.zohocdn.com"><script type="application/ld+json"> { "@context": "https://schema.org", "@type": "FAQPage", "mainEntity": [ { "@type": "Question", "name": "How to make a Gantt chart in Excel", "acceptedAnswer": { "@type": "Answer", "text": "Let's first see how to create a Gantt chart using Microsoft Excel. Before we get into the steps involved, remember that ....<a href='https://www.zoho.com/projects/how-to-make-gantt-chart.html?src=FAQ1'>more</a>" } }, { "@context": "https://schema.org/", "@type": "SoftwareApplication", "applicationCategory": "https://www.zoho.com/projects/", "downloadUrl": "https://www.zoho.com/projects/signup.html", "featureList": "https://www.zoho.com/projects/features.html", "name": "Online Project Management Tools - Zoho Projects", "description": "Zoho Projects is an online project management software to create and manage projects efficiently. Sign up free to plan, track, and collaborate on your projects!", "aggregateRating": { "@type": "AggregateRating", "ratingValue": "4.2", "reviewCount": "257", "bestRating": "5", "worstRating": "1" } } ] } </script><link rel="preload" href="https://static.zohocdn.com/zohofonts/zohopuvi/4.0/Zoho_Puvi_Regular.woff2" as="font" type="font/woff2" crossorigin><link rel="preload" href="https://static.zohocdn.com/zohofonts/zohopuvi/4.0/Zoho_Puvi_Bold.woff2" as="font" type="font/woff2" crossorigin><link rel="preload" href="https://static.zohocdn.com/zohofonts/zohopuvi/4.0/Zoho_Puvi_Semibold.woff2" as="font" type="font/woff2" crossorigin><script src="//www.zohowebstatic.com/sites/zweb/js/common/var_init.js"></script><script>(function(w,s){var e=document.createElement("script");e.async=true;e.src="https://zohotagmanager.cdn.pagesense.io/ztmjs/9e14ca550fb345518206a5a65a40a7a9.js";var x=document.getElementsByTagName("script")[0];x.parentNode.insertBefore(e,x);})(window,"script");</script><title>How to Create a Gantt Chart in Excel | Zoho Projects</title><meta name="description" content="Learn how to make a Gantt chart in Excel, why an online Gantt chart software solution is better than Excel, the pros and cons of Gantt charts and Excel, and more with Zoho Projects. Try now!"><link rel="icon" href="https://www.zohowebstatic.com/sites/zweb/images/favicon.ico" type="image/vnd.microsoft.icon"><link rel="canonical" href="https://www.zoho.com/projects/how-to-make-gantt-chart.html"><meta property="og:title" content="How to Create a Gantt Chart in Excel | Zoho Projects"><meta property="og:description" content="Learn how to make a Gantt chart in Excel, why an online Gantt chart software solution is better than Excel, the pros and cons of Gantt charts and Excel, and more with Zoho Projects. Try now!"><meta property="og:image" content="https://www.zohowebstatic.com/sites/zweb/images/ogimage/projects-logo.png"><meta property="og:url" content="https://www.zoho.com/projects/how-to-make-gantt-chart.html"><meta property="og:site_name" content="Zoho"><meta property="og:type" content="website"><meta name="twitter:title" content="How to Create a Gantt Chart in Excel | Zoho Projects"><meta name="twitter:description" content="Learn how to make a Gantt chart in Excel, why an online Gantt chart software solution is better than Excel, the pros and cons of Gantt charts and Excel, and more with Zoho Projects. Try now!"><meta name="twitter:image" content="https://www.zohowebstatic.com/sites/zweb/images/ogimage/projects-logo.png"><meta name="twitter:card" content="summary"><meta name="twitter:site" content="@zoho"><link rel="stylesheet" href="//www.zohowebstatic.com/sites/zweb/css/common/zohocustom.css"><link rel="stylesheet" href="//www.zohowebstatic.com/sites/zweb/css/product/projects.css"><link rel="stylesheet" href="//www.zohowebstatic.com/sites/zweb/css/node/projects/27563-en.css"></head><body class="zw-page-27563 zw-product-25 zw-product-projects zw-template-just_html i18n-en" data-prdname="projects" data-prdname-display="Projects"> <header><div class="zw-promo-top"></div><div class="zw-global-header"></div><div class="zw-product-header "><div></div></div> </header> <main><div class="zw-template-inner"><div class="wrapper seo-page-template"><div class="banner-wrap"><div class="content-wrap"><div class="banner-cont"><h1>How to Create a Gantt Chart in Excel in Simple Steps</h1><p><a href="/projects/gantt-charts.html" target="_blank">Gantt charts</a> are illustrative reports that help project managers visualize projects in the form of horizontal bars on a timeline. There are many ways to make a Gantt chart online. You can either use dedicated Gantt chart software like Zoho Projects or use workarounds to build one with tools like Microsoft Excel.</p> <a class="cta-btn act-btn" href="/projects/signup.html">Explore Zoho Projects</a></div></div></div><div class="content-wrap"><div class="seo-body-wrap"><div class="left-menu"></div><div class="right-content"><div class="inner-wrap"> <section class="gantt-chart-slider"><div class="zwc-sec-title"><h2>Step-by-step guide to creating a Gantt chart in Excel vs. Zoho Projects</h2><p>Let's see how to create a Gantt chart using Microsoft Excel. Before we get into the steps involved in setting up a Gantt chart in Excel, remember that there are many easier ways to build Gantt charts. There's also more you can do with it when you use a dedicated project management solution with a built-in Gantt chart template like Zoho Projects. Plan smart and choose wisely. Now, onto how to insert a Gantt chart in Excel.</p></div><ul id="nav-1"><li class="slide1"><li><a href="javascript:;" data-tab="tab-1" class="active">Gantt charts in <span>Zoho Projects</span></a></li><li><a href="javascript:;" data-tab="tab-2">Gantt charts in <span>Microsoft Excel</span></a></li></ul><div id="tab-2" class="tab-content gantt-slider-1"><h4>How to create an Excel Gantt chart</h4><ul><li><div class="slide-content"><p><span>Step 01: Add your tasks on an Excel sheet</span> Make a tabulation with task names, start date and duration of the task in an MS Excel sheet.</p><p class="slide-img"><img src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-1.png" width="990" height="540" alt="Gantt Chart Excel"></p></div></li><li><div class="slide-content"><p><span>Step 02: Insert a chart</span> Click on Insert, then on Charts. Choose 2D Stacked Bar chart. A blank chart area should appear on the screen.</p><p class="slide-img"><img src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-2.png" width="990" height="540" alt="How to make Gantt Chart in Excel"></p></div></li><li><div class="slide-content"><p><span>Step 03: Select data under Legend series</span> Right click on the blank chart area and in the menu that pops up, click on Select Data.</p><p class="slide-img"><img src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-3.png" width="990" height="540" alt="Excel Gantt Chart"></p></div></li><li><div class="slide-content"><p><span>Step 04: Select Series Name</span> A dialog box titled Select Data Source will open. Under Legend Series, click on Add.</p><p class="slide-img"> <img alt="How to make a Gantt Chart in Excel" width="990" height="540" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-4.png"></p></div></li><li><div class="slide-content"><p><span>Step 05: Select the first cell</span> The Edit Series dialog box will show up. Click on Series Name and select the first cell of the Start Date column as shown.</p><p class="slide-img"> <img alt="Gantt Excel" width="990" height="540" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-5.png"></p></div></li><li><div class="slide-content"><p><span>Step 06: Remove the default value</span> In the dialog box, remove the default value for Series Values and select the data under the Start Date column. Click on OK.</p><p class="slide-img"><img src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-6.png" width="990" height="540" alt="Gantt Chart in Excel"></p></div></li><li><div class="slide-content"><p><span>Step 07: Click on OK</span> You will be back on the Select Data Source dialog box. Click on OK.</p><p class="slide-img"> <img alt="Create Gantt Chart in Excel" width="990" height="540" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-7.png"></p></div></li><li><div class="slide-content"><p><span>Step 08: Move or resize your chart</span> The chart area will be filled with bars now. Move the chart so that it does not block the data in the sheet.</p><p class="slide-img"> <img alt="How to make a Gantt Chart in Excel" width="990" height="540" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-8.png"></p></div></li><li><div class="slide-content"><p><span>Step 09: Select data again</span> Right click on an empty space within the chart, and click on Select Data in the context menu.</p><p class="slide-img"> <img alt="How to create a Gantt Chart" width="990" height="540" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-9.png"></p></div></li><li><div class="slide-content"><p><span>Step 10: Click on Add</span> In the <i>Select Data Source dialog box</i>, under <i>Legend Entries (Series)</i>, click on <i>Add</i>.</p><p class="slide-img"> <img alt="How to make a Gantt Chart" width="990" height="540" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-10.png"></p></div></li><li><div class="slide-content"><p><span>Step 11: Select the Days To Complete cell</span> The Edit Series dialog box appears. Click on Series name and then select the Days to Complete cell as shown.</p><p class="slide-img"> <img alt="Gantt Charts in Excel" width="990" height="540" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-11.png"></p></div></li><li><div class="slide-content"><p><span>Step 12: Select data under "days."</span> Remove the default value under Series values and select the data under Days to Complete column. Click on OK.</p><p class="slide-img"><img src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-12.png" width="990" height="540" alt="How to make Gantt Charts in Excel"></p></div></li><li><div class="slide-content"><p><span>Step 13: Click on edit under the Horizontal Axis Label</span> You will be back on the Select Data Source dialog box. Under the Horizontal Axis Label, click on Edit.</p><p class="slide-img"> <img alt="How to make a Gantt Chart" width="990" height="540" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-13.png"></p></div></li><li><div class="slide-content"><p><span>Step 14: Click on Axis Label Range</span> In the Axis Labels dialog, click on Axis label range, and select the cells with the names of the tasks. Click on OK.</p><p class="slide-img"><img src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-14.png" width="990" height="540" alt="How to create Excel Gantt charts"></p></div></li><li><div class="slide-content"><p><span>Step 15: Finalize your data to make a Gantt chart</span> Back again on the Select Data Source dialog, click on Ok. We have now selected all the data required to make our Gantt chart Excel.</p><p class="slide-img"> <img alt="Create Gantt Charts in Excel" width="990" height="540" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-15.png"></p></div></li><li><div class="slide-content"><p><span>Step 16: Reverse the order of tasks</span> To reverse the order of the tasks so that it looks like a Gantt chart, click on the task names on the chart, right click and in the context menu that appears, select Format Axis.</p><p class="slide-img"> <img alt="How to make a Gantt Chart in Excel" width="990" height="540" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-16.png"></p></div></li><li><div class="slide-content"><p><span>Step 17: Head to format axis</span> The Format Axis pane will open. Click on Categories in reverse order check box. And close the format axis pane.</p><p class="slide-img"><img src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-17.png" width="990" height="540" alt="How to make Gantt charts"></p></div></li><li><div class="slide-content"><p><span>Step 18: Select format data series</span> Next let's get rid of the bars that are made with the start date data (in the screenshot, they are the ones in blue). For this, right click on the bars as shown and select Format Data Series.</p><p class="slide-img"> <img alt="Excel Gantt charts" width="990" height="540" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-18.png"></p></div></li><li><div class="slide-content"><p><span>Step 19: Click on the paint bucket</span> The Format Data Series pane will open. Here, select the paint bucket icon.</p><p class="slide-img"> <img alt="Create Gantt Chart Excel" width="990" height="540" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-19.png"></p></div></li><li><div class="slide-content"><p><span>Step 20: Your Excel Gantt chart is ready</span> Click on the No Fill option. Your Excel Gantt Chart is now complete.</p><p class="slide-img"><img src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-20.png" width="990" height="540" alt="Make Gantt Excel"></p></div></li></ul></div><div id="tab-1" class="tab-content active gantt-slider-2"><h4>How to make a Gantt chart in Zoho Projects</h4><ul><li><div class="slide-content"><p><span>Step 01: Create your account</span> Signup for a free account, and login to Zoho Projects</p><p class="slide-img"> <img alt="Create Gantt charts in Zoho Projects" width="" height="" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/zoho-projects-1.png"></p></div></li><li><div class="slide-content"><p><span>Step 02: Create a new project</span> Click on the <i>+</i> button on the top bar, create a new project - enter the name of the project, click <i>Add</i></p><p class="slide-img"> <img alt="Create new project - Zoho Projects" width="" height="" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/zoho-projects-2.png"></p></div></li><li><div class="slide-content"><p><span>Step 03: Click on the + icon</span> Once you're inside the project, click on <i>+</i> button again</p><p class="slide-img"> <img alt="Click on the add button - Zoho Projects" width="" height="" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/zoho-projects-3.png"></p></div></li><li><div class="slide-content"><p><span>Step 04: Create a new task</span> Click on <i>Task</i> and enter the details,聽<br> Click on Task and enter the details, <br> Owner - who will handle the task <br> Dates - the opening and closing dates/duration in days</p><p class="slide-img"> <img alt="Click on task and enter details - Zoho Projects" width="" height="" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/zoho-projects-4.png"></p></div></li><li><div class="slide-content"><p><span>Step 05: Add more tasks</span> Click on <i>Add more</i> button after entering the task details to add more tasks and their details</p><p class="slide-img"> <img alt="Add more details - Zoho Projects" width="" height="" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/zoho-projects-5.png"></p></div></li><li><div class="slide-content"><p><span>Step 06: Click on Gantt & Reports</span> After entering all tasks and tasks' details, go to <i>Gantt & Reports</i></p><p class="slide-img"> <img alt="Go to Gantt charts and reports - Zoho Projects" width="" height="" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/zoho-projects-6.png"></p></div></li><li><div class="slide-content"><p><span>Step 07: Create your Gantt Chart</span> Select <i>Gantt charts</i> - Your Gantt chart is ready. Print it, share it and get the ball rolling!</p><p class="slide-img"><img alt="Gantt charts - Zoho Projects" width="" height="" src="//www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/zoho-projects-7.png"></p></div></li></ul></div> </section> <section class="limitation-section"><div class="content-wrap"><h2>Limitations of creating Gantt charts in Excel</h2><div class="limitation-points"><ul><li>Good for a small project with a limited number of tasks. Fitting the chart within a screen may become difficult for large projects.</li><li>Excel Gantt charts with dependencies are hard to represent within the chart. It gets even more complicated if changes are made to the dates while planning.</li><li>Project members cannot work simultaneously to populate tasks in the sheet.</li><li>You are restricted to one view with Gantt charts in Excel.</li></ul></div></div> </section> <section class="alternatives-to-excel"><div class="content-wrap"><div class="zwc-sec-title"><h2>Alternatives to Excel</h2></div><div class="flex-wrap"><div class="inner-wrap"><div class="inner-row"><h3>Kanban</h3><p>Moving cards from one board to another to represent work completion is as satisfying as crossing a work item off a to-do list. For teams with ever-changing workflows, Kanban boards help with visualization, enabling your teams to communicate on the fly and make instant changes to avoid slip-ups. These boards allow multiple collaborators to work on the same activity simultaneously.</p></div><div class="inner-row"><h3>Scrum</h3><p>Scrum boards focus on a chunk of deliverables as opposed to a full-blown project, visualizing all your tasks belonging to one project, in one place. Easily customizable and flexible, Scrum boards keep you up to date on your tasks, allowing you to keep track of your workflows in the form of well-organized sprints in chronological order.</p></div><div class="inner-row"><h3>Dashboards</h3><p>Personalized dashboards that reflect your data in real time keep you on top of all your project-related endeavors. Whether it's the top performing employees or the number of resolved bugs, be certain that your stakeholders are kept informed about all crucial developments.</p></div></div><div class="inner-wrap"><div class="inner-row"><h3>Gantt charts</h3><p>A visual depiction of projects with bars plotted against the project timeline, the Gantt chart paints your projects in the most colorful way possible. Set dependencies between any two tasks of relevance, calculate the actual progress of your project, and highlight critical tasks. Check out Zoho Projects <a href="/projects/gantt-charts.html" target="_blank">Gantt charts</a> for a simple, no-nonsense approach.</p></div><div class="inner-row"><h3>Task lists</h3><p>It doesn't get easier than neatly listing all your tasks and going back to them whenever you want. For people who enjoy the simple things, a task list would suffice, while tools that come with a steep learning curve are shown the door. Particulars like status, priority, start and end date, and more can be arranged and rearranged in order of preference. And when you're in need of new, unique columns that fit your business goals, you can customize an endless number of them. Sample it in Zoho Projects.</p></div></div></div></div> </section> <section class="agile-approach"><div class="content-wrap"><div class="agile-approach-content"><h2>Why should you choose Zoho Projects over Excel for creating Gantt charts?</h2><ul class="agile-approach-list"><li><h3>Plan together</h3><p>One of the best things about making Gantt charts in Zoho Projects is that you can plan together in real time. So, even if you need to change the timeline , you can change it in a few seconds and see what it looks like right away. You can even @mention your team mates inside Zoho Projects. And there's built-in chat, too.</p></li><li><h3>Dynamic context</h3><p>Gantt charts in Zoho Projects are dynamic and adaptive. You can see who's working on the chart, and how far along the project is. With the intuitive color coding system, you get to see which tasks are complete, in progress, or overdue. Clicking on a task gives you more details, and you can leave a comment right inside the Details pane.</p></li><li><h3>Link tasks with dependencies</h3><p>Some tasks are connected. Some need to be done at the same time, while others need to be completed in a particular order. Map them all visually with four types of <a href="/projects/task-dependency.html" target="_blank">task dependencies in Zoho Projects.</a> Click, drag, and done.</p></li><li><h3>Analyze and adapt</h3><p>The project baseline gives you an "expectation vs. reality" view of your timeline. The critical path tells you the tasks you need to prioritize to complete a project. Slack shows you the amount of buffer time you have in your timeline. With these tools, you can revisit your <a href="/projects/project-planning.html">project plan,</a> allocate resources effectively, all while saving time and money.</p></li><li><h3>Easy to use</h3><p>No more digging through menus to find that one hidden button. In Zoho Projects, all options and tools are within your reach. And of course, help is always at hand with live 24/5 support right inside the software. You can also easily import XLS tasks in bulk and view your Gantt chart in an instant!</p></li></ul></div></div> </section> <section class="benefits-of-excel"><div class="content-wrap"><div class="zwc-sec-title"><h2>Benefits of using Excel</h2><p>Creating a Gantt chart in Excel might involve multiple, time-consuming steps, but there are a number of benefits. Here's what you can do with an Excel Gantt chart:</p></div><ul><li><h3>Store data</h3><p>A colossal amount of data can be stored within Microsoft Excel's grid format in the form of tables, charts, and more. Not only that, you can also analyze and sort data based on a number of criteria. From simple grocery lists to complex commutative data, the grid can house it all.</p></li><li><h3>Calculate data</h3><p>Popular for its powerful calculation capabilities, Excel is extensively utilized by students and businesses alike to make advanced statistical or mathematical calculations with the host of integrated formulae and integrations, ramping up data accuracy and saving you a ton of manual effort.</p></li><li><h3>Visualize data</h3><p>Stack your data up in a bar chart or break it down in a pie chart鈥攚ith various visually-appealing ways to display your data in Excel, boring numbers get a face-lift.</p></li><li><h3>Secure your data</h3><p>Protect sensitive data and restrict unauthorized access with encryption, password protection, and access permissions.</p></li><li><h3>Increased efficiency</h3><p>Laden with integrative capabilities, customization tools, and collaborative features, Microsoft Excel takes efficiency and productivity up a notch.</p></li></ul></div> </section> <section class="gantt-chart"><div class="content-wrap"><div class="zwc-sec-title"><h2>Why is online Gantt chart software better than Excel?</h2><p>Microsoft Excel is synonymous with the project management world, given its impeccable data visualization capabilities. Creating a Gantt chart in Excel has its benefits, but none of these can compare to the perks of Gantt chart software. Here's why online Gantt chart software is better than Microsoft Excel.</p></div><ul><li><h3>Set dependencies</h3><p>With a Gantt chart at hand, you can link relevant tasks and create dependencies. Zoho Projects offers four different types of dependencies: Finish to Start, Finish to Finish, Start to Finish, and Start to Start. Calculate and make adjustments to the time lag to fit with your dynamic schedule.</p></li><li><h3>Identify the critical path</h3><p>A critical path is the longest stretch of dependent activities whose completion profoundly impacts the project as a whole. An online Gantt chart software singles out such tasks and ensures you complete them before it's too late.</p></li><li><h3>Real-time insights</h3><p>Any shift in dates or change in project duration is directly reflected in online Gantt chart software, empowering project managers to make informed decisions. What's more, Gantt bars can be resized or moved to fit any kind of ad-hoc change. The Baseline feature paints you a picture of your actual progress versus where you started. You can also draw a comparison between two dissimilar baselines.</p></li><li><h3>Increased visibility</h3><p>With an ever-changing project schedule, it can get quite difficult to keep abreast of intrinsic developments. Gantt charts deconstruct your project into milestones, task lists, tasks, and subtasks, displaying real-time updates of each work item in sheer detail, keeping you and your team on the same page.</p></li></ul></div> </section> <section class="customers-section"><div class="content-wrap"><div class="customers-count"><h2>Over <span>5 million</span> people</h2><p>across the globe trust us. You should too.</p></div></div> </section></div></div></div></div> <section class="agile-approach-footer"><div class="content-wrap"><h2>You deserve the best Gantt chart software there is.</h2><p><a href="/projects/signup.html" class="cta-btn act-btn">Explore Zoho Projects</a></p></div> </section></div></div> </main> <footer><div class="zw-product-footer"></div><div class="zw-global-footer"></div><div class="zw-only-copyright"></div><div class="zw-promo-bottom"></div> </footer> <aside><div class="zw-other-info"></div> </aside><script src="//www.zohowebstatic.com/sites/zweb/js/common/zcms.js"></script><script src="//www.zohowebstatic.com/sites/zweb/js/common/slick-plugin.js"></script><script src="//www.zohowebstatic.com/sites/zweb/js/common/zohocustom.js"></script><script src="//www.zohowebstatic.com/sites/zweb/js/product/projects.js"></script><script src="//www.zohowebstatic.com/sites/zweb/js/node/projects/27563-en.js"></script><script type="application/ld+json"> { "@context": "https://schema.org/", "@type": "HowTo", "name": "How to Make Gantt Chart in Excel?", "description": "Easy step-by-step tutorial on how to create a Gantt chart in Excel.", "totalTime": "PT30M", "step": [{ "@type": "HowToStep", "text": "Make a tabulation with task names, start date and duration of the task in an MS Excel sheet.", "image": "https://www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-1.png", "name": "Make a tabulation with task names" },{ "@type": "HowToStep", "text": "Click on Insert, then on Charts. Choose 2D Stacked Bar chart.", "image": "https://www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-2.png", "name": "Choose 2D stacked bar chart" },{ "@type": "HowToStep", "text": "Right click on the blank chart area. Click on Select Data. A dialog box titled Select Data Source will open.", "image": "https://www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-3.png", "name": "Right click on the blank chart area." },{ "@type": "HowToStep", "text": "Under Legend Series, click on Add. Click on Series Name and select the first cell of the Start Date column. Remove the default value for Series Values and select the data under the Start Date column.", "image": "https://www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-6.png", "name": "Select data - Start date column" },{ "@type": "HowToStep", "text": "Right click on an empty space within the chart, and click on Select Data in the context menu. In the Select Data Source dialog box, under Legend Entries (Series), click on Add. Click on Series name and then select the Days to Complete cell. Remove the default value under Series values and select the data under Days to Complete column.", "image": "https://www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-12.png", "name": "Select data - Days to complete" },{ "@type": "HowToStep", "text": "You will be back on the Select Data Source dialog box. Under the Horizontal Axis Label, click on Edit. Click on Axis label range, and select the cells with the names of the tasks. Click on OK.", "image": "https://www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-14.png", "name": "Select data - Name of the tasks" },{ "@type": "HowToStep", "text": "Click on the task names on the chart, right click and in the context menu that appears, select Format Axis. Click on Categories in reverse order check box.", "image": "https://www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-17.png", "name": "Reverse the order of the tasks" },{ "@type": "HowToStep", "text": "Right click on the bars and select Format Data Series. Select the paint bucket icon. Click on the No Fill option.", "image": "https://www.zohowebstatic.com/sites/zweb/images/projects/gantt-chart-seo/ms-excel-20.png", "name": "Your Excel Gantt Chart is now complete." }] } </script><script type="application/ld+json"> { "@context": "https://schema.org/", "@type": "SoftwareApplication", "applicationCategory": "https://www.zoho.com/projects/", "downloadUrl": "https://www.zoho.com/projects/signup.html", "featureList": "https://www.zoho.com/projects/features.html", "name": "Online Project Management Tools - Zoho Projects", "description": "Zoho Projects is an online project management software to create and manage projects efficiently. Sign up free to plan, track, and collaborate on your projects!", "aggregateRating": { "@type": "AggregateRating", "ratingValue": "4.2", "reviewCount": "264", "bestRating": "5", "worstRating": "1" } } </script></body></html>