•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?
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]
Want to read more?
Check out the full article on the original site
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