The Microsoft Excel spreadsheet editor is a great program for creating all kinds of charts. However, it is worth highlighting one that is excellent for displaying time periods, and it is called the Gantt chart. Its construction is somewhat different from others, so this article will detail how to build a Gantt chart in Excel.
Preparatory stage
Initially, before building the Gantt chart in Excel, you need to prepare the table itself, because it must have the proper form, otherwise nothing will work. Temporary variables must be included in it, which is why the article will build on the example of a schedule for employees to go on vacation. It is also important that the column with the names of employees is not entitled, that is, its heading is empty. If you entered a name there, then delete.
, , , Excel.
№1:
, , Excel, - . :
- . , (), , .
- "".
- "", "".
- . " ".
, . , .
№2:
, Excel , , , , . , :
- .
- , .
- " ".
- "".
- " ".
- "".
, , , , , . .
№3:
, . , :
- , .
- .
- " ".
- . " " ( ).
- " ".
- "".
- , . , , , , , , .
, , . , , , DELETE. , .
, , , .
№4:
, , , , , . , .
. " ". " ". "" "", , "". , . , .
"".
№5:
, , Excel. . :
- "", " ". , , .
- "" " ", " ".
- , . , .
We hope that our example Gantt chart in Excel has helped you, since this is the end of the creation. Of course, you can continue formatting further, but this will already affect the cosmetic part, so to speak. By the way, if you do not want to bother and create it yourself, then on the Internet you can find a bunch of Gantt chart templates in Excel.