User Profile
Atear471
Copper Contributor
Joined 9 months ago
User Widgets
Recent Discussions
Need help Creating a graph
Hello. I'm sorry if this seems like a simple issue but I've been unable to find any specific answers on why what I'm trying to do isn't working. I'm trying to create an excel file that will track clock in times of employees over time. So Employee "A" Clocks in at 8:00am on 4/25/2024 and Employee "B" clocks in at 7:54am on 4/25/2024. Then the next day Employee "A" clocks in at 7:55am on 4/26/2024 and Employee "B" clocks in at 8:05am on 4/26/2024. I believe a scatter plot would work best with the Y axis being the time and the X axis being the date it was entered. But the problem I'm running into is two-fold. First, I have no idea how to change the range of both my x and y axis . For instance, right now my y axis goes from 12am in the morning, to 12am at night, and my x axis goes from 1/0/1900 to 11/21/2036. I can see how to change bonds which I'm assuming is how this is controlled but the values don't make sense for the type of data i'm using, in this case time and date. They are simple numerical values of 0.0 and 1.0. The second issue is that I don't know how to add more than one set of data to a plot as we will have multiple employees I need to keep track of so would ideally like to have them color coded. I appreciate any and all help.Solved1.1KViews0likes4Comments
Groups
Recent Blog Articles
No content to show