However, this requires more advanced techniques of using either formula calculations or creating a sparkline bar chart, which is not covered in this tutorial. There are alternatives to using a stacked bar chart, where you can use a start date and end date in your data. =INT(Task’s End Date Cell)-INT(Task’s Start Date Cell).Duration of Days - This formula uses the selected task’s start date and end date.=INT(Selected Task’s Start Date Cell)-INT(First Task’s Start Date Cell).Days since start - This formula uses the beginning date of the first task (First Start Date) and the start date of any of the tasks (Selected Start Date).If your metrics are start date and end date, use the formulas below to create data columns for the tasks start day and duration of days.
The data for a gantt chart in Excel and Google sheets will require the following: In Excel or Google Sheets, select the cells containing the data for the dimensions and time durational metrics.
