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
Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo
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 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 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 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 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 Beggiora
Ready! Take advantage of the tips to easily create Gantt diagrams in Excel.