![\"Gantt](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/Gantt-chart-in-Google-Sheets-cover.png\")
<\/figure>\n<\/div>\n\n\nHow do I make a Gantt Chart in Google Sheets?<\/h2>\n\n\n\n
The easiest way to create a Gantt chart in Google Sheets is with a stacked bar chart. <\/p>\n\n\n\n
We\u2019ll show you 3 methods you can use to make:<\/p>\n\n\n\n
- \n
- A basic Gantt chart,<\/li>\n\n\n\n
- An advanced Gantt chart with automated progress bars, and<\/li>\n\n\n\n
- A manual Gantt chart.<\/li>\n<\/ul>\n\n\n\n\n
\ud83d\udca1 Plaky Pro Tip<\/strong><\/p>\n\n\n\n
Which should you use, Google Sheets or Excel? Find out below:<\/p>\n\n\n\n
- \n
- Google Sheets vs. Excel: Hands-On App Comparison<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n
Method #1: Basic Gantt chart<\/h3>\n\n\n\n
If you need a universal chart that can be used for various projects spanning weeks or months, go for a basic Gantt chart.<\/p>\n\n\n\n
To make a basic Gantt chart, you should:<\/p>\n\n\n\n
- \n
- Make a task table,<\/li>\n\n\n\n
- Calculate each task\u2019s start day and duration,<\/li>\n\n\n\n
- Create a stacked bar chart,<\/li>\n\n\n\n
- Edit the stacked bar chart to look like a Gantt chart, and<\/li>\n\n\n\n
- Customize your Gantt chart.<\/li>\n<\/ul>\n\n\n\n
Step #1: Make a task table<\/h4>\n\n\n\n
Create a table with 5 different columns in the following formats:<\/p>\n\n\n\n
- \n
- Task (text),<\/li>\n\n\n\n
- Start date (date),<\/li>\n\n\n\n
- End date (date),<\/li>\n\n\n\n
- Start day (number), and<\/li>\n\n\n\n
- Duration (number).<\/li>\n<\/ol>\n\n\n\n
Fill out only the first 3 columns with project information. <\/p>\n\n\n
\n![\"Example](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/example-of-a-basic-task-table.png\")
Example of a basic task table<\/figcaption><\/figure>\n<\/div>\n\n\n Step #2: Calculate each task\u2019s start day and duration<\/h4>\n\n\n\n
To calculate the first task\u2019s start day, type this formula in cell D2: <\/p>\n\n\n\n
=int(B2)-int($B$2).<\/p>\n\n\n
\n![\"Calculating](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/calculating-task-start-day.png\")
Calculating a task\u2019s start day<\/figcaption><\/figure>\n<\/div>\n\n\n Autofill the column when prompted. <\/p>\n\n\n\n
Afterward, change the number format by selecting column D and going to Format > Number > Custom number format<\/em>. Select the decimal-free version.<\/p>\n\n\n
\n![\"Changing](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/changing-the-number-format-in-Google-Sheets.png\")
Changing the number format in Google Sheets<\/figcaption><\/figure>\n<\/div>\n\n\n To calculate each task\u2019s duration, type this formula in cell E2: <\/p>\n\n\n\n
=C2-B2.<\/p>\n\n\n\n
To include a task\u2019s start date in its duration, use this formula instead: <\/p>\n\n\n\n
=INT(C2)-INT(B2)+1.<\/p>\n\n\n
\n![\"Calculating](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/calculating-task-duration.png\")
Calculating task duration<\/figcaption><\/figure>\n<\/div>\n\n\n When prompted, autofill the rest of the column and change the number format to a decimal-free version.<\/p>\n\n\n\n
Step #3: Create a stacked bar chart<\/h4>\n\n\n\n
Select the columns you wish to include in your Gantt chart.<\/p>\n\n\n
\n![\"The](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/the-Gantt-chart-range.png\")
The Gantt chart range<\/figcaption><\/figure>\n<\/div>\n\n\n Generate a stacked bar chart by going to Insert > Chart <\/em>and selecting the stacked bar chart from the Chart type<\/em> drop-down menu.<\/p>\n\n\n
\n![\"Stacked](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/stacked-bar-chart-in-Google-Sheets.png\")
Stacked bar chart in Google Sheets<\/figcaption><\/figure>\n<\/div>\n\n\n Step #4: Edit the stacked bar chart to look like a Gantt chart<\/h4>\n\n\n\n
Go to the Series<\/em> portion of the Chart editor and select Start day<\/em> from the list.<\/p>\n\n\n\n
Once there, change the fill color to white or set the fill capacity to 0% to transform the chart into a Gantt chart.<\/p>\n\n\n
\n![\"Stacked](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/stacked-bar-chart-transformed-into-a-Gantt-chart.png\")
Stacked bar chart transformed into a Gantt chart<\/figcaption><\/figure>\n<\/div>\n\n\n Step #5: Customize your Gantt chart<\/h4>\n\n\n\n
To customize the chart further, go to the Chart editor > Customize <\/em>and find the Chart & axis titles <\/em>section. <\/p>\n\n\n\n
Once there, you can:<\/p>\n\n\n\n
- \n
- Change the Chart title<\/em> text to your project title, <\/li>\n\n\n\n
- Omit or change the horizontal and vertical axis titles, and<\/li>\n\n\n\n
- Adjust each title\u2019s formatting.<\/li>\n<\/ul>\n\n\n
\n![\"Changing](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/changing-chart-and-axis-titles.png\")
Changing chart and axis titles<\/figcaption><\/figure>\n<\/div>\n\n\n In the Legend<\/em> section, you can also omit the chart\u2019s legend by choosing None<\/em> from the list.<\/p>\n\n\n\n
What\u2019s more, you can change the project timeline<\/a> intervals in the Gridlines and ticks<\/em> section by:<\/p>\n\n\n\n
- \n
- Choosing the horizontal axis from the list,<\/li>\n\n\n\n
- Typing \u201c7\u201d in the Major step<\/em> field for a weekly chart.<\/li>\n<\/ul>\n\n\n\n
![\"Changing](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/changing-the-chart-timeline-intervals.png\")
Changing the chart timeline intervals<\/figcaption><\/figure>\n<\/div>\n\n\n Finally, to customize the chart\u2019s appearance, go to the Chart style <\/em>section of the Chart editor and choose:<\/p>\n\n\n\n
- \n
- A new background color,<\/li>\n\n\n\n
- Font, and<\/li>\n\n\n\n
- A new chart border color.<\/li>\n<\/ul>\n\n\n\n
If you change the background color, remember to change the Start day<\/em> fill color to the same shade.<\/p>\n\n\n\n
In the Series<\/em> section, you can also change the fill color for the task duration bars.<\/p>\n\n\n\n
Alternatively, double-click each bar individually to bring up the Format data point <\/em>section and pick a different color for each bar.<\/p>\n\n\n
\n![\"Customizing](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/customizing-the-Gantt-chart-color-scheme.png\")
Customizing the Gantt chart\u2019s color scheme<\/figcaption><\/figure>\n<\/div>\n\n\n And that\u2019s it! You now have your basic Gantt chart.<\/p>\n\n\n\n
Method #2: Advanced Gantt chart<\/h3>\n\n\n\n
In case you want a more detailed view of your project performance, make an advanced Gantt chart with automated progress bars.<\/p>\n\n\n\n
To make an advanced Gantt chart, you have to:<\/p>\n\n\n\n
- \n
- Calculate when each task starts,<\/li>\n\n\n\n
- Make a task progress column,<\/li>\n\n\n\n
- Calculate Completed days and Remaining days for each task,<\/li>\n\n\n\n
- Create a stacked bar chart, and<\/li>\n\n\n\n
- Edit the stacked bar chart to look like a Gantt chart.<\/li>\n<\/ul>\n\n\n\n\n\n\n\n \n Free project management software <\/span>\n
Stop wasting time on creating Gantt charts in spreadsheets. Speed up and streamline your schedule management process with an easy-to-use project management tool \u2014 try Plaky by CAKE.com!<\/p>\n
\n \n Sign up <\/a>\n \n Learn more <\/a>\n <\/div>\n <\/div>\n\n \n ![\"Plaky](\"https:\/\/plaky.com\/blog\/wp-content\/themes\/cake-blog\/theme\/images\/banners\/default.png\")
\n <\/picture>\n <\/div>\n<\/div>\n\n\n \n\n\n\nStep #1: Calculate when each task starts<\/h4>\n\n\n\n
This method starts the same as the previous one, so before moving on, make sure you have:<\/p>\n\n\n\n
- \n
- Created a table and added all the pertinent project details, and<\/li>\n\n\n\n
- Calculated task duration.<\/li>\n<\/ul>\n\n\n\n
Like in method #1, calculate each task\u2019s duration with this formula: <\/p>\n\n\n\n
=C2-B2.<\/p>\n\n\n\n
If you already know the duration and want to calculate the end dates, use this formula instead: <\/p>\n\n\n\n
=B2+D2.<\/p>\n\n\n
\n![\"Calculating](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/calculating-task-end-date.png\")
Calculating a task\u2019s end date<\/figcaption><\/figure>\n<\/div>\n\n\n This chart is suitable for month-long projects, so we won\u2019t need the Start day<\/em> column. <\/p>\n\n\n\n
However, we\u2019ll add a Day of the month<\/em> column (E) next to the Duration<\/em> column.<\/p>\n\n\n\n
To see the day of the month each task starts, use the DAY function in cell E2: <\/p>\n\n\n\n
=DAY(B2). <\/p>\n\n\n\n
Autofill the rest of the column.<\/p>\n\n\n
\n![\"DAY](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/DAY-function-in-Google-Sheets.png\")
DAY function in Google Sheets<\/figcaption><\/figure>\n<\/div>\n\n\n Step #2: Make a task progress column<\/h4>\n\n\n\n
To see the progress of each task, make a Progress<\/em> column (F). <\/p>\n\n\n\n
Format the column to show percentages by navigating to Format > Number > Custom number format <\/em>and choosing \u201c0%\u201d from the list.<\/p>\n\n\n\n
Now, add the percentage of completed work for each task. <\/p>\n\n\n\n
![\"Creating](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/creating-a-progress-column.png\")
Creating a progress column<\/figcaption><\/figure>\n\n\n\n Step #3: Calculate Completed days and Remaining days for each task<\/h4>\n\n\n\n
To figure out how many days have been completed for each task, create a new column (G) and use this formula in cell G2: <\/p>\n\n\n\n
=IF((C2)=””,””,(F2*D2)).<\/p>\n\n\n\n
Autofill the rest of the column.<\/p>\n\n\n
\n![\"Calculating](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/calculating-the-number-of-completed-days.png\")
Calculating the number of completed days<\/figcaption><\/figure>\n<\/div>\n\n\n To see how many days remain for each task, create a new column (H) and use this formula in cell H2: <\/p>\n\n\n\n
=IF(G2=””,””,(D2-G2)).<\/p>\n\n\n\n
Autofill the column when prompted.<\/p>\n\n\n
\n![\"Calculating](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/calculating-the-number-of-remaining-days.png\")
Calculating the number of remaining days<\/figcaption><\/figure>\n<\/div>\n\n\n Step #4: Create a stacked bar chart<\/h4>\n\n\n\n
Select columns A, E, G, and H, go to Insert > Chart<\/em>, and choose the stacked bar chart from the list.<\/p>\n\n\n
\n![\"Default](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/default-stacked-bar-chart-in-Google-Sheets.png\")
Default stacked bar chart in Google Sheets<\/figcaption><\/figure>\n<\/div>\n\n\n Step #5: Edit the stacked bar chart to look like a Gantt chart<\/h4>\n\n\n\n
Go to the Chart editor > Customize > Series<\/em> and pick Day of the month <\/em>from the list.<\/p>\n\n\n\n
Set the fill color to white or change the fill opacity to 0% to make the blue bar disappear.<\/p>\n\n\n
\n![\"Changing](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/changing-the-Day-of-the-month-fill-color.png\")
Changing the Day of the month fill color<\/figcaption><\/figure>\n<\/div>\n\n\n Now, customize the chart further as explained in the previous method by:<\/p>\n\n\n\n
- \n
- Changing or removing the chart and axis titles,<\/li>\n\n\n\n
- Changing the formatting of the vertical and horizontal axis,<\/li>\n\n\n\n
- Removing the chart legend,<\/li>\n\n\n\n
- Changing the timeline\u2019s intervals, and<\/li>\n\n\n\n
- Customizing the chart\u2019s color scheme and appearance.<\/li>\n<\/ul>\n\n\n\n
Once done, your chart may look something like this.<\/p>\n\n\n
\n![\"Customized](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/customized-advanced-Gantt-chart.png\")
Customized advanced Gantt chart <\/figcaption><\/figure>\n<\/div>\n\n\n Method #3: Manual Gantt chart<\/h3>\n\n\n\n
If stacked bar charts don\u2019t appeal to you, and you want more control over the information included in your Gantt chart, you can also build one from scratch.<\/p>\n\n\n\n
To build a manual Gantt chart, you should:<\/p>\n\n\n\n
- \n
- Make a task table and calculate task duration,<\/li>\n\n\n\n
- Format the sequence of days,<\/li>\n\n\n\n
- Format the days of the week,<\/li>\n\n\n\n
- Use conditional formatting to mark the weekends, and<\/li>\n\n\n\n
- Automate the Gantt chart. <\/li>\n<\/ul>\n\n\n\n\n\n\n\n \n Free project management software <\/span>\n
Create an easy project timeline in no time at all! Automate your schedule management with Plaky by CAKE.com.<\/p>\n
\n \n Sign up <\/a>\n \n Learn more <\/a>\n <\/div>\n <\/div>\n\n \n ![\"Plaky](\"https:\/\/plaky.com\/blog\/wp-content\/themes\/cake-blog\/theme\/images\/banners\/features.png\")
\n <\/picture>\n <\/div>\n<\/div>\n\n\n \n\n\n\nStep #1: Make a task table and calculate task duration<\/h4>\n\n\n\n
Make a table with 4 columns in the following formats:<\/p>\n\n\n\n
- \n
- Task (text),<\/li>\n\n\n\n
- Start date (date),<\/li>\n\n\n\n
- End date (date), and<\/li>\n\n\n\n
- Duration (number).<\/li>\n<\/ul>\n\n\n\n
The column titles should consist of 2 cells in total.<\/p>\n\n\n\n
To calculate duration, use this formula: <\/p>\n\n\n\n
=INT(C3)-INT(B3)+1. <\/p>\n\n\n\n
For this method, you want to include the start date in each task\u2019s duration.<\/p>\n\n\n
\n![\"Task](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/task-duration-formula.png\")
Task duration formula<\/figcaption><\/figure>\n<\/div>\n\n\n Step #2: Format the sequence of days<\/h4>\n\n\n\n
Type this formula in cell E1: <\/p>\n\n\n\n
=EOMONTH(B3,-1)+1.<\/p>\n\n\n\n
This formula shows the 1st day of the month given in the Start date<\/em> column.<\/p>\n\n\n
\n![\"Formatting](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/formatting-a-sequence-of-days-in-Google-Sheets.png\")
Formatting a sequence of days in Google Sheets<\/figcaption><\/figure>\n<\/div>\n\n\n The formula shows the exact date, but you want a single number in this column. <\/p>\n\n\n\n
To get that, select the cell, go to Format > Number > Custom number format<\/em>, and type \u201cd\u201d in the empty space.<\/p>\n\n\n\n
Then, to complete the sequence of days, type this formula in the next cell: <\/p>\n\n\n\n
=E1+1.<\/p>\n\n\n
\n![\"Continuing](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/continuing-the-sequence-of-days.png\")
Continuing the sequence of days<\/figcaption><\/figure>\n<\/div>\n\n\n Use the fill handle to copy the formula for the entire month. You may have to add more columns to fit the whole sequence.<\/p>\n\n\n\n
Depending on the month you picked, you\u2019ll have 31, 30, or 28\/29 columns in total. <\/p>\n\n\n\n
Once done, resize and format the columns.<\/p>\n\n\n
\n![\"Formatted](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/formatted-sequence-of-days.png\")
Formatted sequence of days<\/figcaption><\/figure>\n<\/div>\n\n\n Step #3: Format the days of the week<\/h4>\n\n\n\n
To format the cells underneath the sequence of days, use this formula: <\/p>\n\n\n\n
=LEFT(TEXT(E1,”ddd”),1).<\/p>\n\n\n\n
The formula will show the 1st letter of the days of the week that correspond to the sequence of days.<\/p>\n\n\n
\n![\"Formatting](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/formatting-days-of-the-week-in-Google-Sheets.png\")
Formatting days of the week in Google Sheets<\/figcaption><\/figure>\n<\/div>\n\n\n Drag the fill handle to fill out the rest of the columns.<\/p>\n\n\n\n
Step #4: Use conditional formatting to mark the weekends<\/h4>\n\n\n\n
To see which columns are the weekend columns, select the whole Gantt chart area and go to Conditional formatting<\/em>.<\/p>\n\n\n\n
In the Format rules<\/em> section, select \u201cCustom formula is\u201d from the list and type the following: <\/p>\n\n\n\n
=E$2=”S”.<\/p>\n\n\n
\n![\"Custom](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/custom-conditional-format-rule-in-Google-Sheets.png\")
Custom conditional format rule in Google Sheets<\/figcaption><\/figure>\n<\/div>\n\n\n Step #5: Automate the Gantt chart<\/h4>\n\n\n\n
To automate your Gantt chart, select the same area again and go to Conditional formatting > Add another rule<\/em>.<\/p>\n\n\n\n
Select \u201cCustom formula is\u201d from the list and type the following: <\/p>\n\n\n\n
=AND(E$1>=$B3,E$1<=$C3).<\/p>\n\n\n
\n![\"Automating](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/automating-a-Gantt-chart.png\")
Automating the Gantt chart<\/figcaption><\/figure>\n<\/div>\n\n\n Select another color to distinguish between task duration and the weekend columns. <\/p>\n\n\n\n
If you want to layer the task duration cells over the weekend columns, select the Gantt chart area, go to Conditional formatting<\/em>, and drag-and-drop the 2nd rule above the 1st one.<\/p>\n\n\n
\n![\"Completed](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/completed-manual-Gantt-chart.png\")
Completed manual Gantt chart<\/figcaption><\/figure>\n<\/div>\n\n\n \n\ud83d\udca1 Plaky Pro Tip<\/strong><\/p>\n\n\n\n
If you\u2019re still undecided between Google Sheets and Excel, you may want to check out our guide on creating a Gantt chart in Excel and compare the two:<\/p>\n\n\n\n
- \n
- How to Make a Gantt Chart in Excel (+ Free Template)<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n
Get a free Gantt chart Google Sheets template<\/h2>\n\n\n\n
If making a Gantt chart from scratch is too much of a hassle, we\u2019ve created a free automated Google Sheets Gantt chart template<\/a>.<\/p>\n\n\n
\n![\"Google](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/Google-Sheets-Gantt-chart-template.png\")
Google Sheets Gantt chart template<\/figcaption><\/figure>\n<\/div>\n\n\n In the document, you\u2019ll find 5 different Gantt chart templates:<\/p>\n\n\n\n
- \n
- Basic single-project chart,<\/li>\n\n\n\n
- Advanced single-project chart,<\/li>\n\n\n\n
- Basic multi-project chart, <\/li>\n\n\n\n
- Advanced multi-project chart, and<\/li>\n\n\n\n
- Manual Gantt chart.<\/li>\n<\/ul>\n\n\n\n\n
\ud83d\udca1 Plaky Pro Tip<\/strong><\/p>\n\n\n\n
Learn how to effectively handle multiple projects at once in our guide: <\/p>\n\n\n\n
- \n
- Manage Multiple Projects: 10 Best Strategies<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n
How to customize your Gantt chart Google Sheets template<\/h3>\n\n\n\n
Once you\u2019ve copied the template, customize it by:<\/p>\n\n\n\n
- \n
- Changing the project and task titles,<\/li>\n\n\n\n
- Setting task dependencies,<\/li>\n\n\n\n
- Using conditional formatting to indicate task progress,<\/li>\n\n\n\n
- Changing the progress column\u2019s color scheme, and<\/li>\n\n\n\n
- Changing the chart bar colors.<\/li>\n<\/ul>\n\n\n\n\n\n\n\n \n Free project management software <\/span>\n
Why make it hard when you can make it simple? With Plaky by CAKE.com, an interactive Gantt chart is only 3 clicks away.<\/p>\n
\n \n Sign up <\/a>\n \n Learn more <\/a>\n <\/div>\n <\/div>\n\n \n ![\"Plaky](\"https:\/\/plaky.com\/blog\/wp-content\/themes\/cake-blog\/theme\/images\/banners\/templates.png\")
\n <\/picture>\n <\/div>\n<\/div>\n\n\n \n\n\n\nTip #1: Change the project and task titles<\/h4>\n\n\n\n
All of the templates have specific areas for typing in the project title.<\/p>\n\n\n\n
You can also add your own project tasks<\/a> and task owners. The changes will be automatically reflected in the Gantt charts.<\/p>\n\n\n
- Manage Multiple Projects: 10 Best Strategies<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n
- How to Make a Gantt Chart in Excel (+ Free Template)<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n
- Change the Chart title<\/em> text to your project title, <\/li>\n\n\n\n
- Google Sheets vs. Excel: Hands-On App Comparison<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n
![\"Plaky](\"https:\/\/plaky.com\/blog\/wp-content\/themes\/cake-blog\/theme\/images\/banners\/default@2x.png)
\n <\/picture>\n <\/div>\n<\/div>\n\n\n \n\n\n\n![\"Plaky](\"https:\/\/plaky.com\/blog\/wp-content\/themes\/cake-blog\/theme\/images\/banners\/features@2x.png)
\n <\/picture>\n <\/div>\n<\/div>\n\n\n \n\n\n\n![\"Plaky](\"https:\/\/plaky.com\/blog\/wp-content\/themes\/cake-blog\/theme\/images\/banners\/templates@2x.png)
\n <\/picture>\n <\/div>\n<\/div>\n\n\n \n\n\n\n![\"Changing](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/changing-project-and-task-titles.png\")
![\"Finish-to-start](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/finish-to-start-task-dependency-in-Google-Sheets.png\")
![\"Finish-to-finish](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/finish-to-finish-task-dependency-in-Google-Sheets.png\")
![\"Start-to-start](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/start-to-start-task-dependency-in-Google-Sheets.png\")
![\"Start-to-finish](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/start-to-finish-task-dependency-in-Google-Sheets.png\")
![\"Conditional](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/conditional-formatting-in-Google-Sheets.png\")
![\"Automatically](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/automatiically-formatted-progress-column.png\")
![\"Progress](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/progress-column-color-scheme.png\")
![\"Manual](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/manual-Gantt-chart-template-color-scheme.png\")
![\"Custom](\"https:\/\/plaky.com\/blog\/wp-content\/uploads\/2024\/03\/custom-bar-chart-colors.png\")