ACDE
1
Choose language: en
2
Gantt Chart Builder
3
4
Procedure
5
6
Preparatory operations
7
1Make a copy of the template if you haven't alreadyhttps://docs.google.com/spreadsheets/d/1ks9hfoC5bEkcISoVa6W5bttoJ8rbRFflIMlcsZD-bvY/edit?usp=sharing
8
2Create new calendarGoogle Calendar
9
3Copy Calendar IDCalendar settings>>Integrate calendar>>Calendar ID
10
4Insert Project name, Calendar ID and Project Start and End dates into the Settings sheetSettings sheet
11
5Populate the Gantt sheet with Project milestonesGantt sheet
12
6Install the Gantt Chart Builder add-on if it's not already installedExtensions >> Add-ons >> Get add-ons
13
14
Building a Gantt Chart
15
1Select project nameGant sheet >> Cell B3
16
2Select an Create Gantt item from the menuGantt Chart Builder >> Create Gantt
17
18
Uploading project milestones to the calendar
19
1Fill in the calendar with project data manuallyGoogle Calendar
20
2You can also fill the calendar with data sheet automaticallyGantt Chart Builder >> Send *
21
22
Loading project milestones into a sheet from a Calendar
23
1Select an Show item from the menuGantt Chart Builder >> Show
24
2You can also download project stages that meet certain conditionsShow sheet, cells B3, C3, C4
25
To do this, change the values in the cells and repeat select an Show item.
26
Mass removal of project milestones from the calendar
27
1Leave only the milestones you want to delete on the Show sheetShow sheet
28
2Select an Delete item from the menuGantt Chart Builder >> Delete Events >> Delete
29
30
Registration
31
1Enter the password in the cell G1 Settings sheet.Settings sheet, cell G1
32
2Select an Registration item from the menuGantt Chart Builder >> Registration
33
34
More information and feedback
35
https://baublys.ru/gantt-chart-builder/
36
37
* Paid option, requires registration at the end of the trial period