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