SOLVED

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

Copper Contributor

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:

DeviceNameLastContactDateLastContactTime
Computer108/12/202214:41:39
Computer218/01/202308:32:12
Computer317/11/202223:00:56
Computer410/12/202205:54:03
Computer529/11/202217:55:50
Computer631/10/202212: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 Replies
best response confirmed by StevieLamb (Copper Contributor)
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.

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.
1 best response

Accepted Solutions
best response confirmed by StevieLamb (Copper Contributor)
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.

View solution in original post