contador web Skip to content

How to Chart Gantt in Excel | Productivity

The Gantt diagram, or Gantt chart, is a method used to illustrate different stages of a project, linking the person responsible for each phase to the time required to complete it. In Excel, the chart can be done in a few clicks, simply and quickly. The user must select the desired table and click a button to create the diagram automatically. Then you can customize the elements that appear n.

Excel formulas: the 68 most important functions of the program

In the following tutorial, learn how to make the Gantt diagram in Excel from your computer. The procedure was performed on the latest version of Office 2016, but the tips also apply to users of previous editions of the Microsoft program.

How to create charts in Microsoft Excel

How to create charts in Microsoft Excel

Want to buy a cell phone, TV and other discounted products? Meet the Compare dnetc

Step 1. In Excel, assemble and select the table with the activities, start data and end data of each task;

Select table with data Photo: Reproduction / Helito BeggioraSelect table with data Photo: Reproduction / Helito Beggiora

Select table with data Photo: Reproduction / Helito Beggiora

Step 2. Under "Insert", click on the 2D graphics icon as shown in the image, and select the "Stacked Bars" option;

Add displayed graphic type Photo: Reproduction / Helito BeggioraAdd displayed graphic type Photo: Reproduction / Helito Beggiora

Add displayed graphic type Photo: Reproduction / Helito Beggiora

Step 3. Click on the color of the left bar and, in the options column of the right graph, check the item "No fill";

Remove fill from left bar Photo: Reproduction / Helito BeggioraRemove fill from left bar Photo: Reproduction / Helito Beggiora

Remove fill from left bar Photo: Reproduction / Helito Beggiora

Step 4. If you want to change the range, click on the numbers and type "1" in "Main" in the "Format Axis" tab;

Improving time axis accuracy Photo: Reproduction / Helito BeggioraImproving time axis accuracy Photo: Reproduction / Helito Beggiora

Improving time axis accuracy Photo: Reproduction / Helito Beggiora

Step 5. Finally, delete the color caption and click on the chart title to rename it.

Delete subtitle and edit graphic title Photo: Reproduction / Helito BeggioraDelete subtitle and edit graphic title Photo: Reproduction / Helito Beggiora

Delete subtitle and edit graphic title Photo: Reproduction / Helito Beggiora

Ready! Take advantage of the tips to easily create Gantt diagrams in Excel.