Spreadsheet: 622201d1556634307-gantt-chart-with-predecessors-date-tracking-gantt-chart-keebellah-
Sheet: Gantt

Create a Gantt Chart in this worksheet. Enter title of this project in cell B1.  Information about how to use this worksheet, including instructions for screen readers and the author of this workbook is in the About worksheet. Continue navigating down column A to hear further instructions. | PROJECT TITLE
Enter Company Name in cell B2. Enter the Project Start date in cell [NAME] or allow the sample formula to find the smallest date value from the Gantt Data table.  Project Start Date: label is in cell C2. | Company Name | Project Start Date:
Enter the name of the Project Lead in cell B3.  A Scrolling Increment is in cell E3. [NAME] is in cells H3 through M3. Increasing the scrolling increment or using the scrollbar will increment the [NAME] chart timeline.  An input of 0 in cell E3 resets the charting to the start of the project. | Project Lead | Scrolling Increment: |  | 0
To modify the default Milestone [NAME] type, enter a 0, 1, or 2, in cell E5. The corresponding marker will appear in cell F5. To change the markers, modify the conditional format for that cell and the table below. Months for the dates in row 5 are displayed starting in cells H4 through cell BK4. Do not modify these cells. They are auto updated based on the project start date and scrollbar increment. Scrolling Increment: label is in cell C4. |  | Milestone Marker: |  | 1
Cells H5 through BK5 contain the day number of the month for the Month represented in the cell block above each date cell and are auto calculated. Do not modify these cells. Dates leading up to Today are shaded.
This row contains headers for the project schedule that follows below them.  [NAME] from B7 through BK7 to hear the content. The first letter of each day of the week for the date above that heading, starts in cell H7 and continues through cell BK7. All project timeline charting is auto generated based on the category, start date and number of days entered in the Milestones table. [NAME] in these cells help create the look of the Gantt Chart. Do not modify these cells. | Milestone Description | Assigned To | Progress | Start | End | No. Days
Do not delete this row. This row is hidden to preserve a formula that is used to highlight the current day within the project schedule.
Enter Project information starting in cell [NAME] through cell F8.  Sample data is in cells B8 through G32. Enter Milestone Description, assign someone to the item, enter the progress of the task as a percent of completion, enter a start date and duration of task in number of days. The [NAME] chart will auto update as the data is entered. The next instruction is in cell A33. | Title 1
 | Task 1 | Name |  | 2018-11-20 00:00:00 | 2018-12-02 00:00:00
 | Task 2 |  |  |  |  | 1
 | Task 3 |  |  | 2018-11-23 00:00:00 | 2018-11-30 00:00:00
 | Task 4 |  |  |  |  | 1
 | Task 5 |  | 0.1 |  |  | 6
 | Title 2
 | Task 1 |  | 0.6 |  |  | 13
 | Task 2 |  | 0.5 |  |  | 9
 | Task 3 |  |  |  |  | 11
 | Task 4 |  |  |  |  | 1
 | Task 5 |  |  |  |  | 24
 | Title 3
 | Task 1 |  |  |  |  | 4
 | Task 2 |  |  |  |  | 14
 | Task 3 |  |  |  |  | 6
 | Task 4 |  |  |  |  | 3
 | Task 5 |  |  |  |  | 19
 | Title 4
 | Task 1 |  |  |  |  | 15
 | Task 2 |  |  |  |  | 5
 | Task 3 |  |  |  |  | 5
 | Task 4
 | Task 5
This is an empty row
This row marks the end of the [NAME] milestone data. DO NOT enter anything in this row.  To add more items, insert new rows above this one. | To add more data, [NAME] new rows ABOVE this one