Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-17-2022, 06:08 PM
jeevananand jeevananand is offline Trying to plot Team breaks in a Graph Windows 11 Trying to plot Team breaks in a Graph Office 2021
Novice
Trying to plot Team breaks in a Graph
 
Join Date: Dec 2022
Posts: 1
jeevananand is on a distinguished road
Question 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
Attached Files
File Type: xlsx Sample Data.xlsx (11.3 KB, 1 views)
Reply With Quote
  #2  
Old 12-19-2022, 12:07 AM
ArviLaanemets ArviLaanemets is offline Trying to plot Team breaks in a Graph Windows 8 Trying to plot Team breaks in a Graph Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.
Reply With Quote
Reply

Tags
break tracking, plotting breaks, team attendance

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to plot Team breaks in a Graph Data layout and plot velocity squared displacement on a graph for physics? agorgainc Excel 2 12-23-2015 04:06 PM
Trying to plot Team breaks in a Graph 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft