#1
|
|||
|
|||
Trying to plot Team breaks in a Graph
I'm trying to plot a graph to track my team login and break activity, Shift Time: Starts at 8:00 PM and Ends the next day at 4:00 AM, with multiple breaks (IN/OUT) during the day. I want to plot a Stacked Bar or Line graph showing the Employees with a duration between IN and OUT shown in Green and the Breaks which is OUT to IN time in Red
|
#2
|
|||
|
|||
Instead of single column, have 2 columns in source table. In one of them, use NA() to return an error code, when there must be gap in graph, and values otherwise. In another column, use NA() for those rows where you had values in 1st one, and some appropriate value otherwise. Have both columns display a line (coloured differently) in your graph. I don't remember exactly how, but you can have a gap in line graph for N/A's in table.
|
Tags |
break tracking, plotting breaks, team attendance |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data layout and plot velocity squared displacement on a graph for physics? | agorgainc | Excel | 2 | 12-23-2015 04:06 PM |
column clustered bar graph with a line graph as secondary axis | Alaska1 | Excel | 2 | 06-09-2014 07:13 PM |
Priority of line graph vs bar graph in terms of front to back positioning on a chart | DavePPointuser | PowerPoint | 1 | 04-30-2014 10:57 AM |
Difficult Graph To Plot..Please help | Jago147 | Excel | 0 | 02-18-2014 02:30 PM |
Naming plot-line breaks dates on x-axis | Sammael | Excel | 0 | 06-01-2013 03:29 PM |