Hello!
How do I make a bar graph showing employee coverage per day? X-axis is Monday through Friday; Y-axis is 7am to 7pm; data is the range each employee works per day. Adam is 7a-3p M-F, Eve is 10:30a-7p M,W,F, and Ted is 8a-5p M-F. We have several employees and having this visual would be extremely helpful.
Thanks for your help with this!
Last edited by JRose0303; 05-18-2015 at 03:03 PM.
Set up a worksheet containing the data then graph that data.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
I know I need to setup a worksheet containing the data; however, how do I set that data table up and create the graph? Here's the basic layout of the table that I have, but I want the graph to show 7a-7p as the range on the Y-axis, the employees names on the X-axis, and their hour ranges as the data.
Employee MON TUE WED Adam 7a-3p 7a-3p 7a-3p Eve 10:30a-7p 8a-4:30p 10-:30a-7p
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks