Gantt Chart

Gantt chart is a variation of bar chart, created by H. Gantt in the 1910s, that demonstrates a project plan. Excel Gantt chart show the start and finish dates of the critical elements and overview elements of a project.

This free excel chart template also used in IT to represent data that have been received.

Template Features:

You can change the color of bars in the chart. Easy add labels of tasks to bars!

It’s VBA free, the template used only built in Excel functions and conditional formatting.


A work breakdown structure element can be a service, product or any combination thereof. A WBS will provide the necessary structure for in depth cost calculating and manage along with providing path for schedule development too.

Issue Tracking using Gantt Chart

Below you will find a free excel issue tracker template so you can be used to track project management issues.

Project management is the control of planning and managing resources to contribute regarding the completion of your objectives. The Gantt chart is interpretation of when actions are planned.

Excel issue tracker is a superb management tool. By this task planning template you can keep an eye on your project by special actions using the Gantt chart model.

The free excel example is separated into 2 sections: the left section that need standard information about the project. The main section contains graphical information about the project. If you want to highlight cells or a range based on a criteria the best tool is the conditional formatting.


You can set many different activities into this issue tracker template. So you can fill in the columns which are linked to start date and duration of project plan.

You can highlight any periods, insert the number of period in the period highlight field if you want to focus on your necessary stage.

We hope you have been enjoying this article from Excel Dashboard School! Follow us and our excel tutorials on YouTube! Download this template, it is free!

Learn more about Excel chart templates.