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. A metric A metric is a column of numerical data i for the days since the startДue to the toolвЂ™s limitations, the stacked bar chart must start at 0, requiring whole numbers for days from the start of the time period, instead of using a start date in date format.A dimension A dimension is a column of qualitative data that is in text format and non-numeric i (A task, event, or activity).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. Reference Materials Toggle sub-navigation.Teams and Organizations Toggle sub-navigation.

Google sheets best gantt chart