Create Gantt chart using dates and times

Our take

Creating an effective Gantt chart from your manufacturing data can significantly enhance your project management capabilities. By breaking down your extensive dataset into manageable weekly subsets, you can visually represent daily and hourly operations. While your current combined date and time column can be separated for better clarity, using standard Excel tools will allow you to customize your chart effectively. This approach will not only help you track individual operations but also identify overlaps between parts, streamlining your workflow and improving productivity.

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:

https://preview.redd.it/fjbl9dbx04zg1.png?width=3082&format=png&auto=webp&s=1a6932911ec2a108a91603d0ba46cce2a672165e

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!

submitted by /u/Duelsy
[link] [comments]

Tagged with

#Excel alternatives for data analysis#generative AI for data analysis#real-time data collaboration#big data management in spreadsheets#conversational data analysis#financial modeling with spreadsheets#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#natural language processing for spreadsheets#Excel compatibility#real-time collaboration#Excel alternatives#rows.com#large dataset processing#cloud-based spreadsheet applications#Gantt chart