This Gantt chart template is a stacked bar chart and new tasks are added as you type them. Completed (green) and remaining (red) days  are shown in the chart.

The template uses dynamic named ranges. You may have to adjust the dates on the horizontal axis.

Download template

Dynamic Gantt Chart v2.xlsx

Recommended blog posts

Gantt Chart with Repeated Tasks via Excel XY Chart | Peltier Tech Blog