Difficult Graph to Plot, possible need pivot table

Hi all

I’m needing some advice on how best to plot the following. I have a table of dates. I would like a graph showing the progress of work completed.
For example a bar chart that shows the first part of the project as red between this one date and another then on the same bar blue to show that the second part of the project was completed between this date and the next and so on.
I know you cant plot a table of dates however I was hoping there is a way of doing this or something similar maybe using a pivot table. I don’t know who to use a pivot table so instructions would be welcomed.
If you cant think of anything then any suggestions who to display this large about of data in one graph would be great.

Many Thanks


Something like this but with dates as oppose to percentage.

Example 1.jpg

Can you post a spreadsheet with the table in it?

My gut feeling is you want something like a Gantt chart. But we'll see what kind of info you have to work with.