A Gantt chart displays a chronological order of activities. This method is especially suited to plan projects and to generate a visual timeline. In this Office tip we want to show you how to create a Gantt chart in Excel in 8 steps.
Create a table that displays the exact outline of your project. We recommend that you enter all task stages of your project incl. start date, duration and end date.
Add the complete time span of your project to this table. To do so, enter the individual dates as table headers.
Format your data. Right-click that date and select “Format cell”. In “Numbers” select the desired option in the date section. Next, change the order by clicking on “Home” and then in “ab” select the option to rotate the text up.
Click on the date you just created with the left mouse button. Afterward, click on the bottom left corner and drag the cursor down until you have the correct number of days for the duration of your project.
Select the complete time span by selecting the top cells (E, F, …) and reducing the size of these individual fields. To do so, click on the vertical lines between the selected cells and drag them to the desired size.
Add conditional formatting. Select the relevant cells that are to receive this formatting. In “Home” click on “Conditional formatting” and on “New rule”. Select an customized formula as your rule type.
Enter an “AND formula” with two conditions. Begin with “=and( “. Now click on the cell containing the first date of your headers. The formula will appear in the editing bar. For example, for Cell D3 (=$D$3). This value in this cell has to be equal to or higher than the start date. Therefore, enter “>=” and then click on the cell that contains the start date. The formula of this cell will now be entered. Now enter “;” and repeat the procedure for the end date. Click on the cell containing the first date of the headers. The formula of this cell should appear. It will have to be smaller than the end date. Therefore, enter “<=” in the formula and click on the cell containing the end date. To complete the formula, close the bracket and delete the first, fourth, fifth and eighth dollar symbol (“$”) from this formula.
Set a format that reflects the formula by clicking on “Format” and selecting a color you wish to display the bars of your Gantt chart. You have now created a Gantt chart following simple steps. It also has the ability to dynamically adapt to changes and additions automatically.
Then copy the entire Excel table into your desired PowerPoint presentation: Select the table, open the context menu with a right click and click “Copy”. In your PowerPoint presentation, select the desired slide, select a content placeholder and choose “Insert” from the context menu.
Does this sound too complicated?
Want to create a Gantt charts easier and faster? With our product empower® charts, we at Made in Office have made it possible to create elegant Gantt charts directly in PowerPoint, via drag & drop and in your corporate design. Make sure to read more about our powerful charting and layout software.