How to Make or Create a Gantt Chart in Excel – Step by Step

A disorganized worker could lead to a malfunction of your entire office, thus getting you fired or brought to your attention. Therefore, we will teach you how to make or create a Gantt chart in Excel, step by step, quickly and easily.

Also, if you master tools like Microsoft Excel, you will have more value for your company. Why? Well, what happens is that companies consider training in the area of ​​office automation, when evaluating their employees.

As long as you are able to manage with these resources, you will be promoting greater efficiency and rhythm of work. So, don’t just stay with this guide, set a time to study other tutorials. In fact, you can even use the Gantt chart to organize your time spent studying.

To follow the step by step of this article, you need to download and install the Excel software from its official website. Remember that it is a paid program, which you can obtain from Microsoft’s website, however you can purchase a free version.

It is logical that you have doubts about whether to buy it or not, but let me tell you that it is a great investment. If you train, then there will be a chance that you will take better positions in your office. Little by little you will recover that money in spades.

What is a Gantt chart?

Gantt charts are graphical tools that can show us, quickly, the time that we must dedicate to one or more activities, over a certain period already stipulated.

Not only are they a simple way to get organized, but they are also extremely easy to do. By mastering the basics of a worksheet or spreadsheet , anyone can design their own Gantt charts.

excel diagram

How to make or create a Gantt chart in Excel?

First, you must open your Excel spreadsheet, to practice as you read the steps. Now, you will create a table in Excel with four columns, and whose names must be: Activity , Start, End, and DurationYou can choose the number of cells in the columns, depending on how many activities you want to diagram.

Select the columns and go to the start context menu. Use the Borders option , so that our table can be easily established and displayed.

Fill in the cells with the information in their respective columns. Enter the different activities you will do, their start and end dates. You can then manually enter the duration in days for each activity, or use a formula = (End-Initial) +1 , and apply it to all duration cells.

Now that you have completed the table, you will choose the cell next to the Duration , and you will put the number 1. In the next one, the number 2. Then leave both (1 and 2) selected, and drag the small square that appears in one corner from cell 2, to the right. Move it as many cells as days of work you want to diagram.

Select the column where you placed the 1, touching the corresponding letter of the coordinates. Use the right click and choose the Column width option to modify it , put a width of 5 and accept.

Drag and apply the same formatting to all other columns with numbers. When done, select all this new table with numbers in the columns, and apply outer borders.

Finally, color the cells using the shading option. You will do it depending on the duration value for each activity, so that it is something similar to the following image.

gantt excel chart

That would be all. Now is your turn. Put the “creative mode” and design the diagram as well as possible.

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button