How to make a gantt chart in Excel

How to Make a Gantt Chart in Excel

Lucid Content

Reading time: about 5 min


  • Lucidchart tips
  • Project management

Gantt charts visualize an entire project from start to finish, making it easy to communicate responsibilities and prioritize tasks. But making a Gantt chart is easier said than done. Many turn to Excel, but while this program is perfect for organizing and storing large amounts of data, you may find that Excel lacks the flexibility to help you schedule and plan projects effectively.

Give others a clear picture of the project’s timeline with an easy-to-understand Gantt chart of your own. Use this step-by-step guide to learn two approaches to creating a Gantt chart in Excel.

Option #1: Quickly add a Gantt Chart in Excel with Lucidchart

Option #2: Manually make a Gantt chart in Excel

Option #1: Quickly add a Gantt chart in Excel with the Lucidchart add-in

Building a Gantt chart in MS Excel requires 18 steps of time and patience. Don’t limit yourself to only using Excel—instead use Lucidchart’s integration with Microsoft Office. The intuitive diagramming tools available in Lucidchart make it simple to create sharp, professional diagrams in minutes. Plus, it’s easy to set up and add diagrams directly into your spreadsheet.

Register an account with Lucidchart to start building your own Gantt chart.

Sign up today

How to install the Lucidchart add-in for Excel

First, download the Lucidchart add-in for Excel. To do so, follow these simple steps:

  1. Open Excel. 
  2. Go to Insert > Add-in > Get add-in.
  3. Search and select “Lucidchart Diagrams for Excel.” 
  4. Click “Add.” 
  5. Accept the terms and conditions.  
  6. Log in with your Lucidchart credentials to access your documents.

How to insert a Gantt chart into Excel with the Lucidchart add-in

Insert a Gantt chart into your spreadsheet, as a high-resolution image, without ever leaving Excel. 

  1. In Excel, find the Lucidchart button in the upper-right corner. 
  2. Click ”Insert Diagram.” 
  3. Select your Gantt chart from the list. 
  4. A preview will appear in the bottom box. If it is the correct document, click “Insert.” 
  5. To edit your Gantt chart, select “Edit.” Make the necessary changes in the pop-up window and then click “Insert” to update your diagram.

insert a gantt chart into Excel with Lucidchart

How to build a Gantt Chart in Excel with the Lucidchart add-in

Create and edit your own Gantt chart in Excel using the Lucidchart editor within the Microsoft add-in. 

  1. In Excel, select “Insert Diagram” to open the Lucidchart panel. 
  2. Click “Create New Diagram.” 
  3. Choose either a blank document or template to start. 
  4. Drag and drop shapes and edit the text to build your Gantt chart. 
  5. Save your Gantt chart and click back into your Excel spreadsheet. 
  6. Select your new diagram from the sidebar and click “Insert.” 

Build a gantt chart in Excel with the Lucidchart editor

Visit our Help Center or watch the video tutorial below for additional instructions on installing and using the Lucidchart add-in.

Option #2: Manually make a Gantt chart in Excel

You can still make a Gantt chart from scratch in Excel following the steps listed below. But keep in mind that the process will be more time-consuming and less intuitive than using Lucidchart and you won’t have the opportunity to use pre-made templates. 

Format your data and select your bar graph

  1. Input and title each column: “Start Date,” “End Date,” “Task Description,” and “Task Duration.”
  2. Add your project data to the spreadsheet. 
  3. Go to Insert > Chart > Bar chart > Stacked bar chart.

Excel Gantt chart with stacked bar graph

Add data to your Gantt chart  

  1. Right-click on the chart and find “Select data.” A “Select Data Source” box will appear. 
  2. Click “Add.” An “Edit Series” dialog box will appear. 
  3. Select the “Series name” box. 
  4. With your cursor in the “Series Name” box, select the “Start Date” cell in your worksheet. Click back into the “Series name” box.  
  5. Select the “Series value” box. 
  6. With your cursor in the “Series value” box, select all the values in the “Start Date” column on your spreadsheet. Click back into the “Series value” box. Click “OK.”
  7. Back in the “Select Data Source” box, click “Add.”
  8. Repeat the same process for “Task Duration.” 

Excel Gantt chart with select data source boxExcel Gantt chart with edit series box

Format your Gantt chart 

  1. Select “Start date” on the left side of the “Select Data Source” box. Then, click the “Edit” button in “Horizontal (Category) Axis Labels.”
  2. Select the “Axis label range” box. 
  3. With your cursor in the “Axis label range” box, select the values under the “Task Description” in your spreadsheet. Click “OK."
  4. Select the left-most bars of the horizontal bar graph. Right-click and select “Format Data Series.”  A sidebar will appear. 
  5. Select the paint bucket icon. Under the “Fill” options, select “No Fill.” 
  6. Do not close the formatting window. Select the task descriptions on the left of the chart and click on the bar chart icon. 
  7. Under the “Axis options,” click the “Categories in reverse order” checkbox.

Done! You've created your own Gantt chart in Excel. 

Excel Gantt chartExcel Gantt chart revese categoriesBuild a Gantt chart in Excel

Gantt chart examples

Ensure your project goes off without a hitch when you get started with one of our Gantt chart templates. Just click the template to open it with your Lucidchart account and start editing.

Basic Gantt chart Lucidchart template
Basic Gantt Chart (Click on image to modify online)
Gantt chart with progress bar Lucidchart template
Gantt Chart with Progress Bar Example (Click on image to modify online)
Go-To-Market Gantt Chart Lucidchart template
Go-To-Market Gantt Chart Example (Click on image to modify online)

Choose Lucidchart to create a Gantt chart for Excel 

Pick the program that makes the most sense for your goal. If you need to store a lot of data, Excel is clearly your best option. To plan and execute a project with many moving pieces, save yourself the time and headache, and choose Lucidchart to build your Gantt chart. With dozens of templates, easy-to-use tools, and an intuitive interface, Lucidchart helps you visualize your entire project from the beginning. 

Find out how to use a Gantt chart and adapt when changes come your way.

Learn more

About Lucidchart

Lucidchart, a cloud-based intelligent diagramming application, is a core component of Lucid Software's Visual Collaboration Suite. This intuitive, cloud-based solution empowers teams to collaborate in real-time to build flowcharts, mockups, UML diagrams, customer journey maps, and more. Lucidchart propels teams forward to build the future faster. Lucid is proud to serve top businesses around the world, including customers such as Google, GE, and NBC Universal, and 99% of the Fortune 500. Lucid partners with industry leaders, including Google, Atlassian, and Microsoft. Since its founding, Lucid has received numerous awards for its products, business, and workplace culture. For more information, visit

Related articles

  • How to Make a Gantt Chart in Excel

    Learn two approaches on how to make a Gantt chart in Excel with this complete step-by-step guide. Free templates included!

  • 7 alternatives to Gantt charts

    Gantt charts come with a series of fatal flaws that leave many managers looking for Gantt chart alternatives to meet their needs. Try these alternatives in Lucidchart. Templates included!

Bring your bright ideas to life.

Sign up free

or continue with

Sign in with GoogleSign inSign in with MicrosoftSign inSign in with SlackSign in

By registering, you agree to our Terms of Service and you acknowledge that you have read and understand our Privacy Policy.

Get started

  • Pricing
  • Individual
  • Team
  • Enterprise
  • Contact sales

© 2024 Lucid Software Inc.