WinCalendar allows you to convert almost any calendar or schedule data to a static Gantt Chart in Excel. The data for the Gantt Chart can come from any of the following sources supported by WinCalendar:
WinCalendar also allows use of Excel's Autofilter with the Gantt Chart so you can easily filter and sort data rows. Here is a screen shot of a Gantt Chart created with WinCalendar:
The created Gantt Chart is cell based and not Excel chart based. This makes it easier to manipulate and analyse the data.