Averaging multiple days

**Neophema** · 04-20-2011, 09:17 AM

I am trying to track reoccurring values by time - events occurring each day, at the same time, and then averaged by time to chart the values.

This spreadsheet has events occurring at the same time each day, multiple days. I am trying to create a chart which tracks averages by time, regardless of date.

Please see my example spreadsheet.

**pike** · 04-21-2011, 04:16 AM

Hi Neophema,
The best way is use the power of Pivot Table/charts... see attachment

**Neophema** · 04-21-2011, 02:33 PM

Originally Posted by pike

Hi Neophema,
The best way is use the power of Pivot Table/charts... see attachment

Great tool, Thank you!

**pike** · 04-21-2011, 05:23 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save