Forum Discussion
Solved
Plotting events in a chart against date (X-axis) and time (Y-axis)
Hi,
Using Excel 2016 on Windows 10.
I have some data on computers and when they last communicated with their server.
The data looks like this:
| DeviceName | LastContactDate | LastContactTime |
| Computer1 | 08/12/2022 | 14:41:39 |
| Computer2 | 18/01/2023 | 08:32:12 |
| Computer3 | 17/11/2022 | 23:00:56 |
| Computer4 | 10/12/2022 | 05:54:03 |
| Computer5 | 29/11/2022 | 17:55:50 |
| Computer6 | 31/10/2022 | 12:56:42 |
I would like to create a chart with LastContactDate on X-axis, LastContactTime on Y-axis, and simply a point at the intersection of each date/time representing a computer.
The goal is to see the "spread" of how many computers have contacted on each day.
Is there an Excel chart which can do this?
How do I create that chart and set it up?
Thanks,
Stevie
You can create an XY Scatter chart based on the second and thirds columns, see the attached demo.
Click on the chart then click Select Data on the Chart Design tab of the ribbon to see how the series has been defined.
You can create an XY Scatter chart based on the second and thirds columns, see the attached demo.
Click on the chart then click Select Data on the Chart Design tab of the ribbon to see how the series has been defined.
- Thanks, appreciate your help - particularly the attachment, which helped me understand how to configure the axes. That was the element I battled with for hours before raising this post.
