Automate a data table into a Gannt Chart

[Cantrecallmyusername]

hi there,
I have multiple projects with many different stages within the lifecycle I want to reflect in a good visualization where each project is represented on a single line/path and all the various phases can be showed with this line.
Essentially a Gannt chart but without the breakout of the tasks.
Any ideas on how to approach this and make it dynamic to build based on the inputs in the table

(I cant download the addin for the table on my work computer)
This is some mocked up date - there will more projects and more phases but the concept is that each item will have a Task Id and if applicable will be related to to a parent TaskID

TaskID	TaskName	ParentTask	TaskStart	TaskEnd	RAG	Assignee
1	Project 1		01-Aug-23	27-May-24​	Green	joe Bloggs
2	Project 2		01-Aug-23	27-May-24​	Green	joe Bloggs
9	Project Charter	1	01-Aug-23	31-Aug-23​	Green	joe Bloggs
10	Scope and Analysis	1	01-Sep-23	30-Sep-23​	Green	joe Bloggs
11	Requirements	1	01-Oct-23	31-Oct-23​	Green	joe Bloggs
12	Development	1	01-Nov-23	30-Nov-23​	Green	joe Bloggs
13	Testing	1	01-Dec-23	31-Dec-23​	Green	joe Bloggs
14	Implementation	1	01-Jan-24	31-Jan-24​	Green	joe Bloggs
15	Project Charter	2	01-Aug-23	31-Aug-23​	Green	joe Bloggs
16	Scope and Analysis	2	01-Sep-23	30-Sep-23​	Green	joe Bloggs
17	Requirements	2	01-Oct-23	31-Oct-23​	Green	joe Bloggs
18	Development	2	01-Nov-23	30-Nov-23​	Green	joe Bloggs
19	Testing	2	01-Dec-23	31-Dec-23​	Green	joe Bloggs
20	Implementation	2	01-Jan-24	31-Jan-24​	Green	joe Bloggs

Above is my input and below is how I would like this to be presented - the dates wont always line up as evenly as this - i.e a phase my traverse a couple of months and I would like to be able to represent the data in the cells as needed by the start and end dates in my table.
Any help on this one would be fantastic.

 

[Cantrecallmyusername]

I have come up with the below attempt but still not perfect - I cant seem to get my X axis to begin at Jan 2023 and end Dec 2023 and keep all the information on the Phases.
I have used the date value number for Max and min as options but with no success
I have excluded the start date in my chart as I only want the effort based on the end date included

Any ideas on how I can update my X axis here?