show work status

[Yqy]

Would like to show follwing data to look like what is draw. Some of the End date are missing in the data i have. Do i use Gantt chart for this? 

start date	End date	No of work done	No of work ongoing	work type
23/1/2023	21/2/2023	1		m
10/2/2023	2/3/2023	1		c
12/3/2023	23/4/2023	1		c
22/4/2023	21/5/2023	1		m
2/5/2023	18/6/2023	1		m
29/6/2023	Nil		1	c
…	…	…	…	…