Step-by-step guide to creating a Gantt chart in Excel vs. Zoho Projects

Let's first see how to create a Gantt chart using Microsoft Excel. Before we get into the steps involved, remember that there are many easier ways to build Gantt charts. There are also more things 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.

  • How to create an Excel Gantt chart

    Step 01: Add your tasks on an Excel sheet Make a tabulation with task names, start date and duration of the task in an MS Excel sheet.

    Gantt Chart Excel

  • Step 02: Insert a chart Click on Insert, then on Charts. Choose 2D Stacked Bar chart. A blank chart area should appear on the screen.

    How to make Gantt Chart in Excel

  • Step 03: Select data under Legend series Right click on the blank chart area and in the menu that pops up, click on Select Data.

    Excel Gantt Chart

  • Step 04: Select Series Name A dialog box titled Select Data Source will open. Under Legend Series, click on Add.

    How to make a Gantt Chart in Excel

  • Step 05: Select the first cell The Edit Series dialog box will show up. Click on Series Name and select the first cell of the Start Date column as shown.

    Gantt Excel

  • Step 06: Remove the default value In the dialog box, remove the default value for Series Values and select the data under the Start Date column. Click on OK.

    Gantt Chart in Excel

  • Step 07: Click on OK You will be back on the Select Data Source dialog box. Click on OK.

    Create Gantt Chart in Excel

  • Step 08: Move or resize your chart The chart area will be filled with bars now. Move the chart so that it does not block the data in the sheet.

    How to make a Gantt Chart in Excel

  • Step 09: Select data again Right click on an empty space within the chart, and click on Select Data in the context menu.

    How to create a Gantt Chart

  • Step 10: Click on Add In the Select Data Source dialog box, under Legend Entries (Series), click on Add.

    How to make a Gantt Chart

  • Step 11: Select the Days To Complete cell The Edit Series dialog box appears. Click on Series name and then select the Days to Complete cell as shown.

    Gantt Charts in Excel

  • Step 12: Select data under "days." Remove the default value under Series values and select the data under Days to Complete column. Click on OK.

    How to make Gantt Charts in Excel

  • Step 13: Click on edit under the Horizontal Axis Label You will be back on the Select Data Source dialog box. Under the Horizontal Axis Label, click on Edit.

    How to make a Gantt Chart

  • Step 14: Click on Axis Label Range In the Axis Labels dialog, click on Axis label range, and select the cells with the names of the tasks. Click on OK.

    How to create Excel Gantt charts

  • Step 15: Finalize your data to make a Gantt chart 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.

    Create Gantt Charts in Excel

  • Step 16: Reverse the order of tasks 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.

    How to make a Gantt Chart in Excel

  • Step 17: Head to format axis The Format Axis pane will open. Click on Categories in reverse order check box. And close the format axis pane.

    How to make Gantt charts

  • Step 18: Select format data series 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.

    Excel Gantt charts

  • Step 19: Click on the paint bucket The Format Data Series pane will open. Here, select the paint bucket icon.

    Create Gantt Chart Excel Create Gantt Chart Excel

  • Step 20: Your Excel Gantt chart is ready Click on the No Fill option. Your Excel Gantt Chart is now complete.

    Make Gantt Excel

  • How to make a Gantt chart in Zoho Projects

    Step 01: Create your account Signup for a free account, and login to Zoho Projects

    Create Gantt charts in Zoho Projects

  • Step 02: Create a new project Click on the + button on the top bar, create a new project - enter the name of the project, click Add

    Create new project - Zoho Projects

  • Step 03: Click on the + icon Once you're inside the project, click on + button again

    Click on the add button - Zoho Projects

  • Step 04: Create a new task Click on Task and enter the details, 
    Click on Task and enter the details,
    Owner - who will handle the task
    Dates - the opening and closing dates/duration in days

    Click on task and enter details - Zoho Projects

  • Step 05: Add more tasks Click on Add more button after entering the task details to add more tasks and their details

    Add more details - Zoho Projects

  • Step 06: Click on Gantt & Reports After entering all tasks and tasks' details, go to Gantt & Reports

    Go to Gantt charts and reports - Zoho Projects

  • Step 07: Create your Gantt Chart Select Gantt charts - Your Gantt chart is ready. Print it, share it and get the ball rolling!

    Gantt charts - Zoho Projects

Limitations of Creating Gantt Charts in Excel

Gantt diagram in Excel
  • Good for a small project with a limited number of tasks. Fitting the chart within a screen may become difficult for large projects.
  • 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.
  • Project members cannot work simultaneously to populate tasks in the sheet.
  • You are restricted to one view with Gantt charts in Excel.

Why should you choose Zoho Projects over Excel for creating Gantt charts?

  • Plan together

    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.

  • Dynamic context

    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.

  • Link tasks with dependencies

    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 task dependencies in Zoho Projects. Click, drag, and done.

  • Analyze and adapt

    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 project plan, allocate resources effectively, all while saving time and money.

  • Easy to use

    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!

  • 01 - Plan together
  • 02 - Dynamic context
  • 03 - Link Tasks with Dependencies
  • 04 - Analyze and adapt
  • 05 - Easy to use

Over 3 million people

across the globe trust us. You should too.

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •