Create Gantt chart using dates and times
Hi, I have a large set of data that covers a years worth of e.g. manufacturing. I'm currently breaking it down into smaller week by week subsets. I'd like to display what was done each day/week as a Gantt chart, preferably hour by hour.
Currently the date & time are in one combined column but I can easily separate this out if it will help.
Some parts have 1 suboperation to complete them, other parts can have multiple suboperations to complete them.
An example of the data I have is below (1 job with multiple operations, 2 with 1 operations all starting at different dates and times):
| Part | Operation | Start Date & Time | End Date & Time |
|---|---|---|---|
| 1 | 10 | 28/03/2025 06:55 | 28/03/2025 15:03 |
| 1 | 20 | 28/03/2025 16:22 | 28/03/2025 17:33 |
| 2 | 10 | 28/03/2025 12:10 | 30/03/2025 17:52 |
| 3 | 10 | 30/03/2025 19:00 | 31/03/2025 04:35 |
I've had a go at it using various info resources I've found across e.g. Reddit, YouTube etc but not quite getting what I'd like. An example of what I've created for one part with multiple operations is below:
This is using a chart, however it's not a PivotTable based chart, so can't easily be customised or edited etc. Also, it doesn't allow me to capture the Part # as well as the OP # on the LH vertical axis. This is key for separating jobs and also allowing me to see where parts may have overlapped as I add in more data.
Due to this being done on a work PC, I'm unable to install any Excel extensions etc that might help. Have to do it all with standard Excel.
Thanks in advance for any assistance people can offer. If anybody needs additional data to help me then please let me know!
[link] [comments]
Want to read more?
Check out the full article on the original site