How to Create a Basic Excel Gantt Chart with Dynamic Task Bar

This is an excel tutorial to create a basic Gantt Chart with dynamic task bar. It uses conditional formatting formula to show task bar in the table based on specific workdays period in each rows. You can follow this tutorial if you plan to create a simple Gantt Chart that consider mapping workdays without holidays/days off only. You can watch steps to create it from blank worksheet until ready to be printed.

About author: Manager

I work as a Civil Engineer. I want to learn everything new in the field of project management and to participate with those interested in learning this field.

Software engineering

How to Create a Basic Excel Gantt Chart with Dynamic Task Bar