Hello Excel experts - I need help creating a bar chart.
I work at a warehouse and have a table of employee names, all invoices each employee worked on for the day, and start and end times that it took them to complete each invoice. Some invoice take 2 minutes to complete while others can take a couple of hours. I was hoping to be able to create a stacked bar chart (one bar for each employee) and the bar to show how long each invoice took - moving through the employee's day. And showing 'down' times when the employee was not working on any invoice (this would be determined by a void in the data).
I have Googled for days trying to find a solution. Can just point me in the right direction.
TIA for helping!
Shar
I work at a warehouse and have a table of employee names, all invoices each employee worked on for the day, and start and end times that it took them to complete each invoice. Some invoice take 2 minutes to complete while others can take a couple of hours. I was hoping to be able to create a stacked bar chart (one bar for each employee) and the bar to show how long each invoice took - moving through the employee's day. And showing 'down' times when the employee was not working on any invoice (this would be determined by a void in the data).
I have Googled for days trying to find a solution. Can just point me in the right direction.
TIA for helping!
Shar
