Gantt Chart in excel VBA

If you want to make a gantt chart in excel VBA like this

which is a result of the following input

Then the various categories like A , B , C can be changed using the following gantt chart macro.

>>>>> Click Here <<<<< for the macro.

I asked GPT for better names to the tasks:

However, if you are designing a task management system, I would suggest more conventional labels:

Stage	Meaning
Created	Newly created
Draft	Being specified
Active	Under execution
Critical	High priority
Closed	Finished

Or, if you prefer a more distinctive terminology:

Label	Interpretation
Seed	Idea born
Draft	Early formulation
Ordinal	Normal progression
Critical	Turning point
Terminal	Final state