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

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

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

Posted on Jun 15, 2015 7:18 PM

Reply

Answer 1

Yellowbox

Level 7

21,197 points

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

Hi Hadley,

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

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.

Reply

Answer 2

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.

Also, my chart looks like this:

What am I doing wrong?

Reply

Answer 3

Jun 16, 2015 6:12 PM in response to South Hadley Mass

.

Reply

Answer 4

Yellowbox

Level 7

21,197 points

Jun 16, 2015 6:09 PM in response to South Hadley Mass

Hi Hadley,

Try Min 5:00am and Max 9:00pm

Yes it puts a date in but the axis does not display the data. It is Numbers Date & Time (time elapsed since midnight on 1 January 1904).

Regards,

Ian.

Reply

Answer 5

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

Reply

Answer 6

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

Caught one on my own.... Select line > Style > Data Symbol > None

I'm still befuddled on why my actual data is not showing on the chart...

Reply