Multiple events/day over a year

[haznavy]

I need to create a graph/chart which displays frequency of occurrences/day for 51 seperate occurrences but cannot figure out how to do it.

Goal: Illustrate a trend which corresponds to time of occurrence regardless of day

Hypothesis: Greatest number of occurrences occur betwen the hours of 1800 - 2000.

This appears to be more of a statistical issue that I should be able to solve using the data analytics add-in, but I haven't been able to get it to function well enough to produce a coherent product.

Data set included as attached. Thank you for your time and assistance.

v/r

haznavy

 

[Luke M]

Hi haznavy,

Thanks for the data set. I think the attached contains what you are looking for in the chart.

 

[haznavy]

Luke, Thank you very much....exactly what I was looking for. For some reason I could not get my data to display in this fashion. Thanks.

 

[r1c1]

Also see, http://chandoo.org/wp/2008/08/14/plot-time-series-data-excel/ for alternative representation of this type of data.

 

[haznavy]

Also see, http://chandoo.org/wp/2008/08/14/plot-time-series-data-excel/ for alternative representation of this type of data.

Interesting way to present the data. Still really looking for a way to show day:time correlation.