•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Gantt chart (Stacked Bar)
Our take
Creating a Gantt chart in Excel can be challenging, especially when you're navigating staff schedules and shift durations. If your x-axis is extending beyond the intended hours or you're unsure how to format durations, you're not alone. With the right approach, you can clearly visualize your team's shifts from 6 AM to 2 AM and effectively manage their workload.
Hi all, ive been trying to make a chart with no luck.
The chart should show the y axis with the list off staff members and the x axis the time from 6am to 2 am. Ive made a small chart for the data of staff names, shift start time and then the duration in hours. Start times formatted to time (eg 06:30) however im not sure how to format the duration. The x axis also keeps showing time through multiple days, and the data for duration seems to stretch too far than a few hours.
Any help is welcome, im not well experienced in excel so i apologise
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Create Gantt chart using dates and timesHi, 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]
- How can I get x-axis time labels on my bar chart to be normalI am attempting to create a chart showing most common access times. I separated the hours and minutes from the access time information (exported from website to .csv), than got the times down to the nearest half hour. I would like there to be 48 possible times listed on the bar chart, showing how many times each occurred, but for some reason it's listed as a range like "07:50:37 AM - 08:20:00 AM" instead of just "08:00 AM". Anyone know a fix? Put simply, I would like a single number (08:30 AM for example) and not a range of times. https://preview.redd.it/bhfhskmbp7rg1.png?width=1441&format=png&auto=webp&s=8f14608150d03e17bcfb07fcaa175f77ac88a692 submitted by /u/Feeling_Lobster_7914 [link] [comments]
- Stacked bar chart with multiple itemsNeed some help formatting above into 1 stacked chart if possible: X-axis: just the months Y-axis: the total numbers Stack the Active and Non-Actives on top of each other by versions ie. Forecast, Budget 2026, Q2 Snapshot and each of these would fall into a month I can do this with 3 different charts but I want to combine them into one Table Current stacked charts Ideal stacked chart submitted by /u/jaymz023 [link] [comments]
- Creating a work schedule visualiserHello! I'd like to take a list of dynamic work shift times, 10:00-14:00, 12:00-18:00, etc, and paste them into column A of a sheet which will visually 'map out' the whole day with conditional formatting. The sheet columns would run from the beginning of the day, say 08:00, hourly, until the end of the day. A shift time of 08:00-12:00 pasted into column A would therefore fill in the cells from column 08:00 to column 12:00. I'm certain this is possible but my research has turned up nothing but incorrect AI slop. Excel version 2602 submitted by /u/Chegolas [link] [comments]