How to Make a Gantt Chart in Excel

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.

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 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.” 

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.

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.” 

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. 

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.

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.