Have a look at sheet List1 (2) of the attached.
You can click the button or press Ctrl+i on the keyboard after selecting a cell amongst the data.
It assumes quite a number of things including:
data starts at row 3
sorted by time ascending
times in column C
works on the active sheet
Chart gets plotted at the top of the sheet, stats written to cell J23
Check the statistics are correct.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote