Udemy logo

excel gantt chartMicrosoft’s spreadsheet application Excel, found within the Office suite of programs, allows users to input, analyze, and create pictographic representations of various types of data. The most basic and often-used parts of Excel is the spreadsheet, containing various cells into which data may be entered, then analyzed, but just below the surface of this application, there is a plethora of charts, graphs, and other methods of analyzing data, and the one we will be discussing today is the Gantt chart, created by management consultant Henry Gantt in the 1910’s. This bar chart allows the user to break down a project into its component parts, then formulate a schedule, illustrating start and finish dates, as well as various relationships between project activities.

Today, we will tell you a bit about Gantt charts, how to create one in Excel, and some of the benefits of this handy tool. If you happen to be new to the world of Excel, we have a course for newbies that will introduce you to the aspects of this program.

Gantt Chart Basics

As mentioned before, a Gantt chart is used for project management when there will be a significant amount of work needed over a long course of time, weeks, months, or even years. If you’re interested in finding out exactly what a project manager does, we have two articles that can tell you: this one shows you what they do, and this one shows you how they do it. Gantt charts allow you to differentiate between dependent and independent components of the project, indicating to those using the chart whether one aspect has to wait for another to finish, or if it may start in conjunction with others.

As convenient as Gantt charts are for specific situations, they may not be for everyone. Below are some of the positive and negative aspects to using a Gantt chart.

Advantages

Disadvantages

How to Set Up a Chart

Excel does not have a built-in Gantt chart option, so Excel users who want to put project information into this format must customize one of the ready-made charts to their needs. Here we will provide a step-by-step process of how to construct a Gantt chart in Excel, along with accompanying screenshots.

  1. Because Excel doesn’t have a Gantt chart option, you must use data that you have already entered into the standard spreadsheet. To do this, first open a blank spreadsheet, then list on the left side the tasks to be completed, along with pertinent information regarding when and how long these tasks will take.Gantt Chart Example
  2. Next, this data must be entered into a bar chart. To do this, select the Insert tab from the top of the page. Then, click the Bar chart icon, and from the drop-down menu, choose Stacked Bar Chart, after which, a blank chart will appear onscreen.Insert Empty Stacked Bar Chart
  3. Now you must add the information from the spreadsheet into the chart you just created. Do this by right-clicking the newly added empty chart, and click Select Data.
  4. Add the two series you desire to the Horizontal Axis Labels box – in this example, the series we want to add are Start Date and Duration. Click OK. Select Data Source
  5. Next, get rid of the legend by clicking on it and pressing Delete. Then, fix any problems with the order of tasks or any other formatting issues by right clicking on the tasks, then clicking Format Axis. If the tasks are backwards, click Categories in reverse order. Click close. Gantt Chart Second Result
  6. In this example, we want the red portion of the bars gone, so right click the red bars, then click Format Data Series, then Fill, then No fill. Click Close.
  7. Format your chart any other ways you prefer. You should end up with something that looks like this: Gantt Chart Final Result

Now that you are familiar with Mr. Gantt’s nifty chart, you may want to make use of it should you happen to have a potentially complex project needing your attention in the future. As mentioned before, you have to create your own chart from existing data, and if this seems a bit daunting, this course on Excel charts will get you started creating them. Otherwise, get started whipping up this convenient project helper, and get the most out of Excel and the most out of your team.

Page Last Updated: February 2014

Top courses in Excel

Excel students also learn

Empower your team. Lead the industry.

Get a subscription to a library of online courses and digital learning tools for your organization with Udemy Business.

Request a demo