For that, we will highlight the tasks based on the status column D as below. Our aim here is to assess the current phases of each task more easily. Assigning Colors to Tasks in a Multi-Color Gantt Chart In cell range E3:AH3, entered the sequence of dates from the project start date to end date. In B1, used =min(B4:B) to get the project start date, i.e., 01-June-2021, and in B2, used =max(C4:C) to get the project end date, i.e., 30-June-2021. We will use a sample dataset for the example that contains project start date (B1), project end date (B2), task names (A4:A9), task start dates (B4:B9), task end dates (C4:C9), and task statuses (D4:D9). Note:- I’ll share my example sheet in the last part of this tutorial. Multi-Color Gantt Chart in Google Sheets (How-To) Sample Data

Here you can learn how to make two different types of multi-color Gantt chart in Google Sheets. Also, please don’t expect features such as dependencies. Unlike professional Gantt charts, there won’t be any milestone symbols on the bar created using the above three options in Google Sheets.

Plotting individual bars using formulas (SPARKLINE function).

By highlighting cells (Conditional formatting).

Without addon, you can make three types of Gantt charts in Google Sheets. This tutorial demonstrates how to make a multi-color Gantt chart in Google Sheets.Ī multi-color Gantt chart will help you easily assess completed tasks, ongoing tasks, and upcoming tasks with their unique colors.īy checking ongoing and upcoming tasks, you could assess how long a project will take to complete.

Gantt chart maker google