Calculating Average Server Times

[AusKee]

Hey Everyone,


I need to show a chart that displays between 0 & 120 Seconds (including milliseconds) for Server Loading times tested daily and, then average out the worst servers based upon the daily values entered.


In example;


06/15/2017 - 4.02 Seconds
06/16/2017 - 22.92 Seconds
06/17/2017 - 11.03 Seconds
06/18/2017 - 5.90 Seconds
06/19/2017 - 4.62 Seconds
Average Server Loading Time - 9.69 Seconds


I've tried it with time. but, it makes the graph & charts go crazy. It also seems to try and switch the numbers to an actual time as in 01/01/1901 00:10 AM which, also messes up the charts.


I then tried it as currency or a value(number) and even generic. But, it's always incorrectly displaying in charts & graphs.


What would be the best way to accomplish this?

 

[thisoldman]

Corporate web nannies often block images. I don't know a free image host that would allow the chart pictures to get through to all forum viewers.

There's no need to sort and separate the servers. I was playing with the data and wasn't thorough with my explorations before I posted.

This data organization is easiest for me—

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="width: 77"]Date[/TD]
[TD="width: 64"]Citrix Loading[/TD]
[TD="width: 64"]DBM Loading[/TD]
[TD="width: 64"]Citrix Mean[/TD]
[TD="width: 64"]DBM Mean[/TD]
[/TR]
[TR]
[TD="align: right"]06/17[/TD]
[TD="align: right"]5.62[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]5.28[/TD]
[TD="align: right"]3.92[/TD]
[/TR]
[TR]
[TD="align: right"]06/18[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]5.62[/TD]
[TD="align: right"]5.28[/TD]
[TD="align: right"]3.92[/TD]
[/TR]
[TR]
[TD="align: right"]06/18[/TD]
[TD="align: right"]4.62[/TD]
[TD="align: right"]2.39[/TD]
[TD="align: right"]5.28[/TD]
[TD="align: right"]3.92[/TD]
[/TR]
[TR]
[TD="align: right"]06/19[/TD]
[TD="align: right"]5.62[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]5.28[/TD]
[TD="align: right"]3.92[/TD]
[/TR]
[TR]
[TD="align: right"]06/18[/TD]
[TD="align: right"]5.62[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]5.28[/TD]
[TD="align: right"]3.92[/TD]
[/TR]
[TR]
[TD="align: right"]06/19[/TD]
[TD="align: right"]5.62[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]5.28[/TD]
[TD="align: right"]3.92[/TD]
[/TR]
[TR]
[TD="align: right"]06/21[/TD]
[TD="align: right"]5.62[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]5.28[/TD]
[TD="align: right"]3.92[/TD]
[/TR]
[TR]
[TD="align: right"]06/22[/TD]
[TD="align: right"]5.62[/TD]
[TD="align: right"]3.89[/TD]
[TD="align: right"]5.28[/TD]
[TD="align: right"]3.92[/TD]
[/TR]
</tbody>[/TABLE]

New Dropbox link: https://www.dropbox.com/s/uwkznqdwyhqfvf7/AusKee_chart_02.xlsx?dl=0

If you can't download the file, private message me.

You actually don't need a whole column filled with the mean value. If I didn't want to be quick, I would use a single cell containing the average and use formatted error bars to draw the horizontal line on the chart. Using the whole column is just faster and less "fiddly" for me.

Hope this helps.