excel scatter graph using time on the x-axis

[clocka]

Hi all,

im struggling with an excel chart, for some reason its proving rather tricky.
I've setup a powershell script to ping 4 servers each in a different office, every 5 minutes and output it to a log file. I want to see how the ping time alters throughout the day.

Im trying to plot the time the result was taken on the x-axix, the response time of the ping on the y-axis, and then 4 sets of data in the actual graph. I read online for excel to recognise time correctly a scatter graph is needed. After at least 2 hours ive given up and posted here!

the pic below shows the raw data and a mock up of what I want it to look like. any help/suggestions greatly appreciated.

thanks,



Link to the Excel file

 

[Mirmo]

The easiest way would be to decimalise the time. So 04:15 becomes 4.25. As long as the X-axis labels are whole hours, it would look fine.

Obviously if you wanted to include half hour increments, you would have to change some settings so it shows 04.30 instead of 04.50.

Edit: Sorry, just noticed time is on the y-axis