#Gantt chart excel free template xls pro

If you want to show ISO week numbers (1-53) instead of sequential numbers in the column labels, you can choose that option in the Help & Settings worksheet. 'This browser does not support the HTML5 video element'Ī scroll bar is not available in Excel Online or Google Sheets, but you can change the display by modifying the display Week number. Simply select the Display option from the drop-down at the top of the worksheet. The most commonly requested views for the gantt chart are Daily and Weekly, but we've also included Monthly and Quarterly options. Change the Display to Daily, Weekly, Monthly (See the Help & Settings worksheet for more info).

#Gantt chart excel free template xls pro

The help worksheet in Gantt Chart Pro explains a few advanced ways to use the color column, such as entering a formula to change the color code based on urgency, task completion, or the name of the person assigned to the task. Do not overwrite or edit the formulas in these cells. The calculated WBS, Start and End columns are highlighted light gray to help distinguish them as columns that contain formulas. You can modify the rules if you want to use different colors, but this may require advanced knowledge of Excel.Ĭolors 1-6 are not defined in the Google Sheets version.

The colors are defined using conditional formatting rules. You can use the normal spreadsheet formatting features to help distinguish between the main phases of your project.