ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I make a chart based upon time sheets? (https://www.excelbanter.com/charts-charting-excel/192595-how-do-i-make-chart-based-upon-time-sheets.html)

Kevin0612

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