•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Can Excel create a visual representation of when people arrived at and left a place based on time data?
Our take
Are you grappling with how to visually represent time-based arrival and departure data in Excel? You're not alone—many struggle with translating complex datasets into clear visuals. Fortunately, Excel has the tools you need to create an insightful vertical bar chart that captures how long individuals stayed, structured chronologically by their arrival times. Plus, you can enhance your chart by color-coding bars to highlight the reasons for departure. Let’s dive into how you can turn your data into a compelling visual aid that communicates effectively.
I am trying to create a visual aid and was hoping Excel might work, but this is definitely above my pay grade.
I have data showing when people arrived at a location, when they departed, how long they stayed, and three categories for why they left. What I have in mind is a vertical bar chart with the vertical axis showing how long they stayed, and then each bar underneath it chronologically based on arrival time. I have attached a drawing showing what I have in my head.
As a bonus, there are three different reasons for why people left. If I could color code each bar to correspond to one of those, I would be eternally grateful and send you an e-beer.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Gantt chart (Stacked Bar)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 submitted by /u/tmbsketches [link] [comments]
- How do you vary colors of bar graph by day of the week?I feel really stupid for this because I am searching all over and not seeing answers for this. Like is this a basic option I am missing that is so obvious nobody asks it? Basically I have a bar graph for data points throughout the year, I want something like Mondays red, tuesdays blue, wednesdays green, etc etc The option to "vary colors by point" seems to alternate every 14 or so colors and there doesn't seem to be a way to change the interval, that I can tell. Obviously I can manually change colors but this is excel and there has gotta be a way to alternate that rather than do it for each individual point. Especially since I have multiple "yearly" charts I'd like to do this for. submitted by /u/machinelock [link] [comments]
- Creating stacked, clustered bar charts with different variablesI require assistance in creating stacked clustered bar charts with different variables. I have managed to create 2 separate stacked bar charts for my data as shown in the picture. Is there a way to combine the 2 plots into a singular graph despite each plot having different legends? https://preview.redd.it/sqlwnfkrg9lg1.png?width=1397&format=png&auto=webp&s=17345eadcc840e4def6c6245454b3bb17d920631 submitted by /u/madskullboy [link] [comments]
- Centering a bar graph data based on horizontal axis categories rather than by series.I don't know if this is the kind of question normally posed to this community and it is largely aesthetic, but here goes. I am making a graph for data that had technical replicates for each gene (A, B, and C). The genes (102 pqm1, 102 N2, and 96 N2) are on the horizontal axis and are the major category for the graph. Some replicates had a value of '0', which I do want to represent on the graph. The issue that one replicate (102 N2, C) failed and was removed from the data set, but even if I don't include that empty cell in the selection box for the series, Excel centers that category around the second series in that category. This makes it look almost as though there is another '0' value, when in fact that data is simply nonexistent https://preview.redd.it/a5555vq2j2ng1.png?width=646&format=png&auto=webp&s=c3dec2c3608a6fde56336839b732c8780eab98d0 https://preview.redd.it/y3py87b5j2ng1.png?width=193&format=png&auto=webp&s=6f97bd63453454d3967654015500d6be0038ef9f If anyone knows how to individually move bars in this type of graph, or how to make a bar graph that is tied to x-axis categories but not series, I'd appreciate any advice! submitted by /u/Stack_of_penguins [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#real-time data collaboration#Excel compatibility#natural language processing for spreadsheets#big data management in spreadsheets#conversational data analysis#rows.com#cloud-based spreadsheet applications#intelligent data visualization#financial modeling with spreadsheets#no-code spreadsheet solutions#Excel#visual representation#vertical bar chart#duration of stay#bar chart#time data#arrival time#departure time