; gantt
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

gantt

VIEWS: 87 PAGES: 4

  • pg 1
									Prepared by carlton Collins                    8/30/20125:18 PM                                        Page 1 of 4


Trick Excel into Creating a Gantt Chart

Tasks                     Start Date Duration (Days)    End Date
Land Preparation            9/4/2008                  8          9/12/2008
Foundation                 9/12/2008                  4          9/16/2008
Framing                    9/16/2008                  5          9/21/2008
Doors and Windows          9/19/2008                  4          9/23/2008
Plumbing                   9/23/2008                  2          9/25/2008
Electrical                 9/23/2008                  3          9/26/2008
Sheet Rock                 9/26/2008                 12          10/8/2008
Finish Work                10/8/2008                  7        10/15/2008
Painting                  #########                   9        10/19/2008


Steps
                      1   Start by creating a stacked bar chart
                      2   Remove the Data Series by right mouse clicking and choosing Select Data Source
                      3   Add a new Data Source Named Starting Date, and point to the range of start dates for the values
                      4   Add another new data source named Duration (Days), and point to the range of duration days for th
                      5   Add Category Axis Labels and point to the Task names in Column A
                      6   Remove legend by selecting legend and pressing the Delete key
                      7   Click on the beginning series and set the Fill and Borders to None
                      8   Right mouse click on the task labels, choose format Axis, and check the Categories in Reverse Order
                      9   In two blank cells, write a formula referencing the start and end dates, convert these dates to numb
                     10   Use the resulting numbers to set the scale of the Gantt Chart (perhaps use a slightly larger range of d
                     11   Right mouse click on the date range, set the minimum and maximums to fixed using the numbers ac
                     12   Format the date range to show a short date
                     13   Format the remaining data bars to display a 3-D bevel
                     14   For added touch, search Google images for a nice picture of a house, save it to your hard drive.
                     15   Set the background plot area to picture, and wash out the picture enough so that the chart is still rea
                     16   Add a title or text boxes as needed to complete the description of the Gantt Chart



              Painting                          Carlton Collins Contractors
                                                Gantt Chart for Building a Home
           Finish Work


           Sheet Rock


             Electrical


             Plumbing


1d29bd27-4617-4ef9-ac76-86e8c6cc4080.xlsx
Prepared by carlton Collins           8/30/20125:18 PM                  Page 2 of 4

             Plumbing


    Doors and Windows


              Framing


           Foundation


      Land Preparation

                    8/30/08      9/9/08        9/19/08   9/29/08   10/9/08




1d29bd27-4617-4ef9-ac76-86e8c6cc4080.xlsx
             Prepared by carlton Collins               8/30/20125:18 PM   Page 3 of 4


                     39695           39740




start dates for the values
 ange of duration days for the values




Categories in Reverse Order box (if needed)
 onvert these dates to numbers with formatting
 se a slightly larger range of dates)
o fixed using the numbers acquired in the above step



ve it to your hard drive.
gh so that the chart is still readable.




             1d29bd27-4617-4ef9-ac76-86e8c6cc4080.xlsx
Prepared by carlton Collins          8/30/20125:18 PM   Page 4 of 4




    10/19/08




1d29bd27-4617-4ef9-ac76-86e8c6cc4080.xlsx

								
To top