# Need help Creating a graph

Copper Contributor

# 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.

# Re: Need help Creating a graph

To create a graph to track clock-in times of employees over time in Excel, you can use a scatter plot with the Y-axis representing the time and the X-axis representing the date. Here's how you can do it:

1. Data Setup:
• Organize your data in a table format with columns for Employee Name, Clock-in Time, and Date.
• Ensure that the Clock-in Time column contains time values and the Date column contains date values.
• Here's an example of how your data might look:
 Employee Name Clock-in Time Date Employee A 8:00 AM 4/25/2024 Employee B 7:54 AM 4/25/2024 Employee A 7:55 AM 4/26/2024 Employee B 8:05 AM 4/26/2024 ... ... ...

2. Creating the Scatter Plot:

• Go to the "Insert" tab on the Excel ribbon.
• Click on "Insert Scatter (X, Y) or Bubble Chart" and choose a scatter plot option.
• Excel will generate a default scatter plot based on your data.

3. Customizing the Axis:

• Right-click on the Y-axis and select "Format Axis."
• In the Format Axis pane, you can adjust the minimum and maximum bounds of the axis to fit your time range.
• For the X-axis, you can format the axis to display dates in the desired date format.

• To add multiple data series (one for each employee), you can use Excel's "Select Data" feature.
• Right-click on the chart and select "Select Data."
• Enter the employee name as the series name, and select the Clock-in Time and Date columns for the series values.
• Repeat this process for each employee.

5. Customizing Colors:

• After adding multiple data series, you can customize the colors by clicking on each series in the legend and selecting a different color from the "Fill" options.

6. Finalize and Format:

• Once you have added all the data series and customized the colors, you can finalize the chart by adding titles, axis labels, and any other necessary formatting.

By following these steps, you can create a scatter plot in Excel to track clock-in times of employees over time, with multiple data series color-coded for each employee.

NOTE: My knowledge of this topic is limited, but since no one has answered it for at least one day or more, I entered your question in various AI. The text and the steps are the result of various AI's put together. Maybe it will help you further in your project, if not please just ignore it.

My answers are voluntary and without guarantee!