Gantt Chart (automated with Macros)

Professional Excel Templates for your Business

Gantt Chart (automated with Macros)

Gantt Chart (automated with Macros)

Gantt chart is a very useful instrument for project planning. The chart helps to monitor the progress of each task in the project as well as the progress of the whole project.

Distinguishing feature of this Gantt Chart is possibility to:

  • Choose the number of Task Categories;
  • Increase or decrease the number of Sub Tasks in each Task Category.

If you wish to see how this gantt chart template looks in Microsoft Excel you can download a demo version. The demo version is exactly the same as the real template; however, you will not be able to change anything in this version.


If you need customization of this template, click here to purchase some customization hours.

We suggest to use customization for adding Sub Sub Task level or new columns (for example, Task lead column).

Functionality of the Gantt Chart Template:

  • create up to 10 task categories with various sub task categories
  • automatically calculate the progress and end-date for each sub task category as well as for the whole category
  • calculate how many working days are in the period, how many days have gone and how many days are left to finish the task
  • graphically describe task progress


If you don’t wish to use macros we also offer a Gantt chart without this option.

Let us do the work for you!


Contact our team if you’re looking for additional support with your company’s financial needs! You can request model adjustments for any template found on our website or request a completely customized financial template with your company’s data (operational budgets, cashflow projections, valuation models, cost analysis and other models).


Our company has over 12 years of experience as outsourced CFOs creating and improving financial models for different industries. Over these years we have worked with 500+ companies from 20+ countries in the world. We bet you won’t be able to name an industry we haven’t made financial models for.


The customization services are performed by the same team of analysts that organizes the Financial Modeling World Cup (our group’s company). The Financial Modeling World Cup is the world’s largest financial modeling competition, enjoyed by top-class modelers from all over the world. Our team is trusted by such big names as Microsoft, the main sponsors of the tournament, and ESPN who broadcast the tournaments to TV audience. You can learn more about FMWC here.

Drop us a line at and we’ll get back to you with an offer!


Have feedback or suggestions? Get in touch with our founder & CEO, Andrew Grigolyunovich, CFA:

1 review for Gantt Chart (automated with Macros)

  1. Mark R. Grogan

    Nice customization for project management!

Add a review

Your email address will not be published. Required fields are marked *