Simple Project Planning With Excel Gantt Chart

If you’re building a new city, or plotting world domination, you’ll need a powerful project management tool, such as Microsoft Project. For smaller projects, you can list your tasks in Excel, and create a Gantt chart, to show the timeline.

List the Project Tasks

In this example, we’re creating the company budget for next year. The first step is to list all the tasks on an Excel worksheet. The starting date for the first task is entered in column B, and the estimated days for each task is entered in column C.
Then, in cell B3, the WORKDAY function is used to calculate the starting date for the second task. It calculates the date based on the start date of the previous task, the number of days for the previous task, and the days in the list of holidays, on a different worksheet.
=WORKDAY(B2,C2,HolidayList)
GanttChart01

Create the Gantt Chart

To create a Gantt chart, select cells A1:C8, and insert a stacked Bar chart. Then, format the Start Date series with no fill colour, and remove the chart legend.
GanttChart02b
The list of tasks will be in reverse order in the chart, so you can format the axis, to change the order.
GanttChart02
The minimum date on the axis is automatically set, and you can adjust it, to reduce the gap between the axis and the first task.
GanttChart04
Finally, to make the bars taller, adjust the gap width, to zero or a very low percentage.
GanttChart03
The finished chart will show the timeline for the project tasks.
GanttChart05

More on Gantt Charts

For a collection of project management tools, including Gantt charts, take a look at Chandoo’s Excel Project Management Template kit. All the setup work has been done for you – you just have to fill in your project details.
To learn more about Excel Gantt charts, visit Jon Peltier’s website, and check his list of Excel Gantt Chart resources. There are links to Jon’s excellent Gantt chart articles, and many other helpful links.

Download the Sample Gantt Chart File

To see the task list and Gantt chart, and test the WORKDAY formula, you can download the sample Excel Gantt chart workbook. The file is in Excel 2007 format, and is zipped. There are no macros in the file.
Go to the Excel Sample Files page on the Contextures website. In the Charts and Graphics section, look for CH0004 – Gantt Chart.

Watch the Gantt Chart Video

To see the steps for creating the WORKDAY formula and Gantt chart, you can watch this short Excel video tutorial.

Or watch on YouTube: Project Timeline with Excel Gantt Chart
____________