• Create a Gantt chart in Excel : Step 1 - Zoho Projects

    Step 01 Input your task names, start date and duration (days to complete) in an Excel sheet

  • Build a Gantt chart in Excel : Step 2 - Zoho Projects

    Step 02 Go to Insert - click on the Chart option and choose either 2D Stacked Bar chart or 3D stacked bar chart. Once you click on any one of them, a blank chart area appears on the sheet.

  • Make Gantt chart in Excel : Step 3 - Zoho Projects

    Step 03 Right click on the blank chart and click on Select Data

  • Prepare Gantt chart in Excel : Step 4 - Zoho Projects

    Step 04 In the Select Data Source dialog, click on Add under Legend Entries (Series)

  • Use Gantt chart in Excel : Step 5 - Zoho Projects

    Step 05 In the Edit Series dialog box appears, click on Series Name and click on Start Date column header

  • Create Gantt chart in Excel : Step 6 - Zoho Projects

    Step 06 For the Series Values, remove the default value and select the data under Start Date column and then click on OK.

  • Build a Gantt chart in Excel : Step 7 - Zoho Projects

    Step 07 You should be back on the Select Data Source dialog. Click on OK.

  • Make Gantt chart in Excel : Step 8 - Zoho Projects

    Step 08 The chart is now populated. You can move the chart so that it does not block your table.

  • Prepare Gantt chart in Excel : Step 9 - Zoho Projects

    Step 09 Right click on an empty portion on the chart, and click on Select Data

  • Use Gantt chart in Excel : Step 10 - Zoho Projects

    Step 10 In the Select Data Source dialog, click on Add under Legend Entries (Series)

  • Build Gantt chart in Excel : Step 11 - Zoho Projects

    Step 11 In the Edit Series dialog, click on Series name and then select the Days to Complete cell (column header) 

  • Make Gantt chart in Excel : Step 12 - Zoho Projects

    Step 12 Under Series values, remove the default values and select the Days to Complete data, and then click on OK. You will now be back on the Select Data Source dialog.

  • Prepare Gantt chart in Excel : Step 13 - Zoho Projects

    Step 13 Under the Horizontal Axis Label, click on Edit. Axis Labels dialog is now open.

  • Use Gantt chart in Excel : Step 14 - Zoho Projects

    Step 14 Click on Axis label range, and select the cells with the Task names, then click OK.

  • Create a Gantt chart in Excel : Step 15 - Zoho Projects

    Step 15 We are now back on the Select Data Source dialog. Now that we have selected all the data on our sheet click OK.

  • Build Gantt chart in Excel : Step 16 - Zoho Projects

    Step 16 We need to reverse the order of the tasks to make it look like a Gantt Chart. Click on the task names on the chart, right click and select Format Axis.

  • Make Gantt chart in Excel : Step 17 - Zoho Projects

    Step 17 In the Format Axis pane, click on the Categories in reverse order check box. Close the format axis pane.

  • Prepare Gantt chart in Excel : Step 18 - Zoho Projects

    Step 18 Next we need to get rid of the start date bars. Click on the bars on the chart with the start date, right click and select Format Data Series.

  • Use Gantt chart in Excel : Step 19 - Zoho Projects

    Step 19 In the Format Data Series pane, select the paint bucket icon for fill options.

  • Create Gantt chart in Excel : Step 20 - Zoho Projects

    Step 20 Click on No Fill. This will make the start date bars invisible. Your Gant chart is now ready!

  • How to create a Gantt chart in Excel? - Zoho Projectss

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

  • How to make a Gantt chart in Excel? - Zoho Projects

    Step 02 Click on the + button on the top bar, create a new project - enter the name of the project, click ok

  • How to build a Gantt chart in Excel? - Zoho Projects

    Step 03 Once you're inside the project, click on + button again 

  • How to do a Gantt chart in Excel? - Zoho Projects

    Step 04 Click on Task and enter the details, 
    Task name - what is the task, add a title and description (optional)
    Owner - who will handle the task
    Dates - the opening and closing dates/duration in days

  • Free Gantt chart Excel - Zoho Projects

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

  • Create Gantt chart Excel - Zoho Projects

    Step 06 After entering all tasks and tasks' details, go to Gantt & Reports

  • Simple Gantt chart Excel - Zoho Projects

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

Limitations of an Excel Gantt Chart

Gantt chart in Excel - Zoho Projects
  • Good for a small project with a limited number of tasks. Fitting the chart within a screen may become difficult for large projects.
  • Hard to represent dependencies within the chart. It gets even more complicated if ad-hoc 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.

Why is Zoho Projects the best Gantt chart maker?

  • Plan together

    One of the best things about making Gantt charts on Zoho projects is that you can plan together in real time. So, even if your boss wants you to change the timeline during a meeting, you can change it in a few seconds and see how it looks like right away. You can even @ mention your team mates inside Zoho Projects. And there's inbuilt chat too.

  • Dynamic context

    Its not just a visual representation in Zoho's Gantt chart maker. It is dynamic and adaptive. You get more context - see who's working on it, and how far things are done. With the intuitive color coding system on our Gantt chart software, 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 there inside the details pane as well. 

  • Link Tasks with Dependencies

    Some tasks are connected. Some need to be done along with another. Some need to be completed before another and some after. Map them all visually with the dependencies available inside our Gantt Chart software. Zoho Projects supports four types of task dependencies. Click, drag and done.

  • Analyze and adapt

    Baseline gives you an "expectation vs reality view" of your timeline. Critical Path tells you exactly what 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, and in the process save time and money.

  • Easy to use

    All options and tools are at your reach. No more digging through menus to find that one hidden button. In Zoho Projects, you get what you see. And of course, help is always at hand with live 24 x 5 support right from inside the software.

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

Over 2.5 million people

across the globe trust us. You should too.

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •