There are so many times when we’ve wished Excel would draw an automated GANTT chart that it is not even funny anymore. Unfortunately, the folks at Microsoft only have tedious workarounds that require using the graph wizard! Trust me – that approach requires you to suffer needless pain with often unsatisfactory results. The graph wizard was never meant to draw a GANTT – period!
If you want an automated GANTT chart in excel for your projects that looks like the example below, then simply download my template by clicking on the download button on the right. Your client / boss / team will love you for it!
The template is easy to use; you simply enter the list of projects, their start and end dates; the GANTT will display as soon as you enter the 2 dates for a project. The duration column is also calculated automatically as the number of whole months between the start and end date.
The magic is only in the cells/area that show the GANTT; There is a formula in each cell. I’ve simply used conditional formatting to achieve the coloring based on the result of the formula in each cell. If you would like the bars to display in another color, simply change the conditional formatting.
Hope this helps. If you have any questions, feel free to reach out. Till my next post, be safe and have a great new year and don’t forget to rate my post (use the start rating at the top) !!