Plotting events in a chart against date (X-axis) and time (Y-axis)

[StevieLamb]

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

[#2 · Accepted solution]

@StevieLamb 

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.

[#3]

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.