Here, too, you have to adapt the chart data area and remove the coloring from the areas of the bars that aren’t relevant for your Gantt chart. Define additional starting points and timespans. First of all, add more columns to your table. To illustrate this, several bars have to be visible in the same row. This Gantt chart Excel template makes for a perfect project planner, allowing you to track and synchronize the activities of a project. In the course of a project, it’s also possible that certain tasks will come up again and again. You can now also select the area with the cursor.

Write the correct cell references either directly in the cell or click on the button on the right edge of the row. To add new tasks, you have to extend this. You can see the area currently selected in the top menu row. In the menu that opens, you have the possibility to include data into your chart. After clicking the button, you can then click on “Select data.” right at the bottom. As soon as you’ve activated the complete diagram with a mouse click, you’ll see the filter symbol. If you’d like to introduce another task, though, you have to adapt the chart data area. Excel’s advantage is that if you’d like to make a change, for example altering the timespan or renaming a task, you can do this directly in the table, and the graphic will update automatically.

Excel gantt chart maker