Gantt diagram from excel data

We are missing a better visualization of our production. We are working on a larger project where the customer must be able to follow the planning of our production. We use an order and planning tool which, unfortunately, the customer does not think gives a sufficient visual overview.
What we want is an excel sheet with the option of inserting a weekly extract from our planning tool. The data must then be converted into a visually clear Gant diagram of the coming production.

The project is the implementation of technical equipment in many different buildings. Each implementation has a set of tasks that are interdependent. We have the implementation in the following assignment:
- [PROJ] parent timeline
- [Survey] building survey
- [Electric] Electrical installation
- [CTS] Technical work
- [Extra] task without start time and deadline

Requirements for the Gant chart
- Each task type must have its own color. (edit possible)
- There must be filters and sorting options with task´s grouped in there project.
- The timeline must be adjustable so that it, for example. only looks 4 weeks ahead.
- Gant chart must have a current date stroke
- Excel sheets must be prepared for export data the quantity gets bigger.

Best wishes

/Dennis