here is a free template using Excel 2013, no VBA is required, you need Powerquery Installed
the template use a schedule forecast data ( P6, P3, Ms Project etc) and the MTO data to generate any Gantt chart you may think of
https://datamonkeysite.wordpress.com/2016/11/11/how-to-build-a-level-5-s... [1]
want, schedule by tag, and area fine, construction by subsystem etc
comments are welcome