Gantt Chart In

Document Sample
Gantt Chart In Powered By Docstoc
					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.
University of Florida                           EEL 4914/4924—Spring 2008                        Dr. Eric M. Schwartz
Electrical & Computer Engineering                       Revision 1                                             24-Jan-08
Page 2/2                               Creating A Gantt Chart in Excel

                                                                Proje ct KlipKlop Spring 2008 Sche dule
                                                                            Ke lly (K) & Pat (P)




                                                                                                                                  8




                                                                                                                                             8




                                                                                                                                                        8
                                                                                             8
                                                            8




                                                                                                           8




                                                                                                                                 -0




                                                                                                                                            -0




                                                                                                                                                       -0
                                                                           08




                                                                                          -0
                                           08




                                                           -0




                                                                                                          -0




                                                                                                                                ar




                                                                                                                                           ar




                                                                                                                                                      pr
                                                                                        eb
                                                                          b-
                                                       an
                                       n-




                                                                                                       ar




                                                                                                                            -M




                                                                                                                                       -M




                                                                                                                                                  -A
                                                                                     -F
                                                                      Fe
                                                      -J
                                      Ja




                                                                                                      M
                                                     21




                                                                                   18




                                                                                                                           17




                                                                                                                                      31




                                                                                                                                                 14
                                      7-




                                                                     4-




                                                                                                    3-
      P roblem determined K+P

                    Research K+P

                  Super Bowl - K

                   T ether Ball - P

                  Clean house - K

                      Clean car - P

                        Fix car - K

            T ake out garbage - P

                      Software - K

                      Software - P

                     Hardware - K

                     Hardware - P

       Appologize to SO - K+P

                P resentation K+P

                                                                Subtask 1        Subtask 2            Subtask 3