•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