Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Table and chart for employee work hours vs. fixed work hours

Hi all:


I'm pretty adept to Numbers (currently running 3.2.2), but I'm stymied on this; I am trying to complete a table and chart that outlines an employee's timesheet (e.g. actual time in/out versus fixed open/closed work hours). Does anyone know an appropriate chart that would reflect the constant open/close hours and the actual time in and time out of the employee? Also, any direction on how to execute the table-to-chart procedure?


Also, I know how to alter the steps for the Y axis, but not the value "range". Any thoughts on that as well?


Cheers,

Hadley

User uploaded file

MacBook Air, OS X Mavericks (10.9.5), 2.13/4G

Posted on Jun 15, 2015 7:18 PM

Reply
6 replies

Jun 15, 2015 10:34 PM in response to South Hadley Mass

Hi Hadley,

User uploaded file

I used a table with column A as a Header Column and Row 1 as a Header Row.

Select all columns and insert a Line graph

User uploaded file

To change the value range for Y, click in the Max and Min boxes and type a time. I used 5:00am and 9:00pm (no spaces).

If you want the In and Out lines on top of the Open and Close lines, change the order of the columns in the table.


I removed the data points on the Open and Close lines by clicking on the graph then clicking on the series to select it.

Format Panel > Style > Data Symbol > None (I think it looks neater that way).


Regards,

Ian.

Jun 16, 2015 4:39 PM in response to Yellowbox

Hi Ian,


Thank you for taking the time to help me and go through all of that. I had a couple of questions/issues I'm running into. In the Axis Scale, it is set to Auto (which I know is default), but when I enter Axis Scale > Scale > Max of '5:00am' and hit enter, it puts a date in the field.

User uploaded file User uploaded file


Also, my chart looks like this:

User uploaded file

What am I doing wrong?

Jun 16, 2015 8:44 PM in response to Yellowbox

Hi Ian,


I'm almost there. Thanks to your direction, I have the Y axis range workable. Now that I've done so, my chart still looks a bit off from yours. What you originally have is EXACTLY what I'm aiming for, but I cannot see the graph with the actual line variables of Time In/Time Out (blue & green columns) nor can I get that beautifully horizontal Open Time/Closed Time lines like you have. Here is a snap of what I have thus far... Many thanks for your help! ~Hadley

User uploaded file

Table and chart for employee work hours vs. fixed work hours

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.