Hi,

Please help me with a FORMULA to create a GANTT CHART from the attached excel file (series of data to be used: Column A (Category), Column B (From date) and Column C (To). Each horizontal bar should be colored as per the corresponding labels in Column A (Category), as follows:
- Maintenance Leased unit (blue color):
- Rental (red color);
- Replacement (purple color):
- Shop invoice (green color):

Thank you,
Moshe