Caution : As file is taken from internet make sure you open documents in protected mode of excel.

Simple approach to produce Gantt charts using visual basic. This spreadsheet uses visual basic, so you will need to set macro-security to low or medium since otherwise it will not work.