Creating Gantt Charts in Excel 2007

As well as being a great way to store, tabulate and analyse your data, Microsoft Excel has many other features which can be used to really help you in your day to day life. One of these features is the ability to set up your own Gantt charts.

Gantt charts are ideal for managing your time and resources. From large scale projects to weekly tasks that need to be monitored, using Gantt charts is a great way of getting organised, which is why we take you through a step by step walk through of how to make your own.

Data

First off, we need some data to convert into a chart. The example below goes through a university work schedule plan, but you can make yours to match whatever topic you most need planning.

Excel Gantt chart tutorial

Make sure that your dates are properly formatted by:

  • selecting from B2 to B6
  • right clicking
  • Format
  • Click on the Number tab
  • Select Date from the Category list (you can select how it is formatted from here)

Creating a Bar Chart

Now you need to select all of the data, which in this case is from cells A1 to D6. In Excel 2007, click on the Insert tab so you have access to the Charts tool bar. From here you need to select Bar Chart (see image below).

Excel Gantt chart tutorial

Now you need to select Stacked Bar Chart as seen below:

Excel Gantt chart tutorial

This will create your stacked table which will become your Gantt chart. It should look something like this:

Excel Gantt chart tutorial

Editing your Chart

Now you have your stacked bar chart it’s time to turn it into a Gantt chart. To do this, first of all we need to select the first set of data in the chart (the blue section of the chart), right click and select Format Data Series.

Excel Gantt chart tutorial

From this menu you need to set the boarder style to no line and fill to no fill. This will cause the blue bar to disappear so you are left with something like this:

Excel Gantt chart tutorial

From here you need to reorganise the data to make it look more like a Gantt chart. To do this, you need to select the x-axis (which is reversed from normal, in charts is actually the vertical y-axis). Right click and select Format Axis, from here you can select “Categories in Reverse Order” under the Axis Options tab.

Excel Gantt chart tutorial

Now all we have to do is the final formatting to the horizontal, y-axis. Reduce the size of the font and change it to whatever font works best from you. It is possible to define your own scale to the chart from within the Axis Option, but in this case we will leave them as automatic. Then we are done, you now have your own Gantt chart set up.

Excel Gantt chart tutorial

If you would like to learn how to do more neat tricks in Excel such as this then why not have a look at some of our expert training courses for all standards, including Beginners Excel Training and the more advanced VBA for Excel Training courses, so you can become a master of Excel.

Tags

, , , , , , , , , ,
Andy Trainer


Connect with Andy on Google.

View all posts by Andy Trainer

One Comment

Jimmy says:

Take a look at mine Gantt Chart tutorial: http://excel-is-easy.blogspot.com/2011/09/gantt-chart-in-excel.html

Leave a Comment