![]() |
How do I make a chart based upon time sheets?
I have the data as follows:
Name Time In Time Out Time In Time Out (to account for lunch breaks). What I want to do is create a chart that graphically shows how many people are in the building at any given time. So I want the times on the bottom and the person's name on the vertical axis, and then have a line that runs across the cells that the person is on the clock. Any ideas? Thanks. |
All times are GMT +1. The time now is 11:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com