Gantt Chart

What is a Gantt Chart? Speed 1.25X

Create a Google Sheet. And add the following lines . . . You can Copy and Paste from here for ease . . .

Column A

PROJECT TASK

INITIAL IDEA EXPLORATION

IDEA EXPLORATION

DESIGN DEVELOPMENT

CREATION PROCESS

FINAL PROJECT & REFLECTION

Column B

START DATE

1/18/23

2/15/23

3/27/23

4/17/23

5/15/23

Column C

FINISH DATE

2/13/23

3/26/23

4/16/23

5/14/23

5/19/23

Column D

DURATION

Select A-D Columns and center them.

Add the following formula to cell D3:

This will subtract the amount of days between C3 and B3 and then add a day extra.

=(DAYS(C3, B3)+1)

It will auto fill cells C4-C7

With the following 18 cells selected
Hold down the {CRTL} key and drag select the following cells

Choose Insert > Chart

A chart shows up but it is not the style we are going to use. We will need to make a few changes.

We need to change the chart type to a "Stacked Bar Chart" Double click on the chart and in the settings change Chart Type to "Stacked Bar Chart"

Double Click the chart horizontal labels and the setting will show on the right. Change the Min to 44942 & Max to 45068

With the settings still open, change the Number Format to

Choose Date and Time

Choose the format you want, I chose 8/5/30 to keep it simple.

The dates now reflect the chart data.

Double-Click on the chart's blue bar, settings will open, and under the series settings change the Fill Opacity to 0%.

Under the series settings change the Fill Opacity to 0%.

Double-Click on the grid lines, change the Major Spacing to Step and the Major Step to 7. This sets up the grid line interval to weekly.

And the first date is on a Monday - 1/16/23.

the Start Date

I chose white to hide the Start Date key since we are not using this bar.