HTML Preview Gantt Chart page number 1.
University of Florida EEL 4914/4924—Spring 2008 Dr. Eric M. Schwartz
Electrical & Computer Engineering Revision 1 24-Jan-08
Page 1/2 Creating A Gantt Chart in Excel
Information about Gantt Charts can be found at http://www.ganttchart.com/ .
I created an example Gantt Chart available at http://mil.ufl.edu/4914/docs/Gantt_example.xls . You can
modify this chart, changing the tasks and the starting dates and days per subtask or you can create your
own.
There is an excellent website that can help you make a Gantt Chart at http://ganttproject.biz/ .
There is a step-by-step procedure for creating a Gantt Chart in Excel at the following URL:
http://office.microsoft.com/en-us/excel/HA010346051033.aspx
This procedure was not very clear. I suggest you use my example chart instead.
I used Excel to create a Gantt Chart with the data below for two imaginary students (Kelly and Pat).
Start Date Subtask 1 Subtask 2 Subtask 3
Problem determined K+P 7-Jan-08 7 3 3
Research K+P 9-Jan-08 14 0 0
Super Bowl - K 28-Jan-08 12 3 0
Tether Ball - P 28-Jan-08 12 3 0
Clean house - K 11-Feb-08 10 5 5
Clean car - P 11-Feb-08 21 7 7
Fix car - K 17-Feb-08 5 2 0
Take out garbage - P 24-Feb-08 7 7 0
Software - K 3-Mar-08 28 0 0
Software - P 5-Mar-08 10 2 2
Hardware - K 15-Mar-08 5 5 0
Hardware - P 17-Mar-08 14 7 7
Appologize to SO - K+P 31-Mar-08 14 7 3
Presentation K+P 14-Apr-08 5 5 0
The example Gantt Chart corresponding to this table is shown below on the following page. Please be
sure to make all figures, tables, and charts big enough so that the information can be easily read.