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