Basic GANTT Chart in Google Sheets Using Stacked Bar Chart

Are you looking for an easy way to create a basic GANTT chart in Google Sheets? Well, look no further! In this guide, I will show you how to make a simple GANTT chart using the Stacked Bar Chart feature in Google Sheets. While it may not be suitable for large projects, it will definitely come in handy for your personal use or smaller projects. So, let’s dive right in!

How to Make a Basic GANTT Chart Using Stacked Bar Chart in Google Sheets

Before we begin, let’s take a look at the sample data we’ll be using for our GANTT chart. You can find the sample data here. Feel free to make a copy of the sheet for your reference.

Now, let’s start by formatting the data:

1. Copy and paste only the tasks from the sample data into a new range (A12:A20 in this case).

2. In cell B13, enter the formula =DATEVALUE(B3)-DATEVALUE($B$3) to find the number of days from the project start for each task. Alternatively, you can use the array formula =ArrayFormula(days(B3:B10,B3)) to generate the number of days for all tasks.

3. In cell C13, enter the formula =DATEDIF(B3,C3,"D") to calculate the duration of each task. You can also use the array formula =ArrayFormula(days(C3:C10,B3:B10)) as an alternative.

With the data formatted, we can now create the GANTT chart using the Stacked Bar Chart feature. Here’s how:

1. Select the data range A12:C20.

2. Go to the menu Insert > Chart.

3. In the chart editor panel, change the “Chart Type” to “Stacked Bar Chart”.

4. Under the “Series” section, set the series color for “Start on Day” to ‘None’. This will remove the series from the chart.

Voila! Your basic GANTT chart using the Stacked Bar Chart feature is ready in Google Sheets.

Enhancement in the Basic Stacked Bar Based GANTT Chart

Google Sheets has recently updated its charts interface, so let’s take advantage of that and enhance our basic GANTT chart.

1. Instead of using the helper cell range A12:C20, add a new range alongside the existing data in A2:C10.

2. In cell D2, enter “Task Duration”.

3. In cell D3, enter the array formula =ArrayFormula(days(C3:C10,B3:B10)) to calculate the task duration for each task.

Make sure to adjust the chart settings to reflect these changes:

• Chart Type: Stacked bar chart.
• Stacking: Standard.
• Data range: A2:D10.
• Y-axis: Task.
• Series 1: “Project Start” (set fill color to white).
• Series 2: “Task Duration” (set fill color to blue).

That’s it! You now have an enhanced GANTT chart using the Stacked Bar Chart feature in Google Sheets.

To learn more about GANTT charts in Google Sheets and explore other useful resources, check out Crawlan.com.

Happy charting, and may your projects always stay on track!