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

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

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

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

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

    Step 03 Right click on the blank chart area and in the menu that pops up, click on Select Data.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Step 12 Remove he default value under Series values and select the data under Days to Complete column. Click on OK.

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

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

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

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

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

    Step 15 Back again on the Select Data Source dialog, click on Ok. We have now selected all the data required to make our Gantt chart.

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

    Step 16 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.

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

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

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

    Step 18 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.

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

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

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

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

  • 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 create Gantt chart?

    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

  • How to make Gantt chart?

    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!

Limitation of an Excel Gantt Chart

Gantt chart in Excel - Zoho Projects
  • Works just fine for a small project with a handful of tasks. Fitting the chart within the view for larger timelines and larger projects with more number of tasks will be difficult.
  • Dependencies cannot be represented on an Excel Gantt chart. And even if you make do with shapes and arrows, any change in the timeline during discussions would be a nightmare.
  • Members working on the project cannot collaborate and plan together simultaneously on an Excel Gantt chart.
  • You are stuck with one view only.

Why Zoho Projects is the best Gant chart maker.

  • Plan together

    With the Gantt charts on Zoho Projects, you can plan together in real time. That means, if your boss wants you to change the timeline during a meeting, you can change it right there in seconds. You can @ mention your team mates and there's inbuilt chat too.

  • Dynamic context

    Zoho's Gantt chart maker is dynamic and adaptive. You get more context - see who's working on it, and how far the tasks are complete. With the intuitive color coding system on Zoho's free Gantt chart software, you get to see the status of all tasks at a glance. Clicking on a task gives you more details, and you can leave a comment right there inside the details pane if you want.

  • 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 click and drag 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 fiddling 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.

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •