Create & Display Dynamic Gantt chart on Userform Excel vba

Workbook with two worksheets and userforms. 'Data Input' userform already created and coded. Userform to display gantt chart created but requires coding to display dynamic Gantt chart

Copy of workbook as database will be uploaded to business one.drive and shared with max of 5 users to use at any one time (downloaded and saved to user one.drive)

5 x columns on worksheet to be used for gantt chart:
- Company name
- Start Date
- End Date
- Total Days
- Total Working Days

Dynamic Gantt chart required to display in userform displaying (vba coding required):
X - axis - 4 x 'dates' data labels displayed at top
- 1. rolling calendar dates in days
- 2. rolling calendar dates in weeks
- 3. rolling calendar dates in months
- 4. rolling calendar dates in years

X - axis - Horizontal Bar Chart area
- to display customer 'booked time slot' - could be anything from 1 working day up to 2, 3, 4, weeks
- A 'Provisional' time slot would display in colour orange
- A 'Confirmed' time slot would display in Green
* When a 'Provisional' time slot has been 'Confirmed', (cmd btn) colour would change from orange to green).
* Open to all and any suggestions on types of configurations on how to display days, weeks, months, years

Y - axis - Customers name

Seeking a freelancer to work on this immediately

AI explanation:
This project requests the development of a dynamic Gantt chart within an Excel userform for workload scheduling and resource management. The workbook contains two worksheets, including a populated “Data Input” userform for raw data. An additional userform has been created but requires VBA coding to generate the Gantt chart visualization.

The chart will display on the userform with the X-axis showing four timescale filters - dates in days, weeks, months, and years. A horizontal bar chart area below will include colored bars to represent customer booking slots from one day to multiple weeks. Provisional slots will show orange, and slots that are confirmed will turn green when the status is updated.

Data for the chart pulls from five columns on a worksheet: company name, start date, end date, total days, and working days. The dynamic chart should automatically refresh and resize based on this data. When complete, the anonymized workbook will be uploaded to a shared online drive for up to five simultaneous users to access, view, and edit booking information from their individual accounts.

This project provides an opportunity to develop a useful project management tool with interactive Excel capabilities. Coding is needed to link the chart area to the raw data and allow user-driven changes to slot statuses and visualizations. Design customization for optimal display of the timescale and booking slots is also welcome. The client seeks a skilled freelancer