Frequency plotting

I have a column of data that has various times listed. I am trying to
find out how to plot some type of histogram or frequency chart that
shows what are the busiest hours.

For example column A lists the following times (in 24 hour format)
7:57
9:55
11:16
11:24
11:32
12:13
12:25
12:50
13:09
13:33

I want to be able to plot something that returns from 7:00 - 7:59 there
was 1 hit, from 9:00 - 9:59 there was 1 hit, from 11:00 - 11:59 there
were 3 hits, from 12:00 - 12:59 there were 3 hits, and from 13:00 -
13:59 there were 2 hits.

Thanks in advance!


--
trebor18
------------------------------------------------------------------------
trebor18's Profile: http://www.excelforum.com/member.php...o&userid=28187
View this thread: http://www.excelforum.com/showthread...hreadid=477181

Under Tools select Addins.. and check Analysis Toolpak (might as well pick both). If you want 7:00 - 7:59, etc. as your ranges place the times of the bottom of each range in a column e.g.
7:00
8:00
9:00
...

Select Tools, Data Analysis, Histogram. Select you data in A as the Input Range, the ranges (see above) as the Bin Range and then a cell that is in a clear column with another clear column to its right as the Output range, then OK.
This is the data to use in the graph.

Originally Posted by trebor18

I have a column of data that has various times listed. I am trying to
find out how to plot some type of histogram or frequency chart that
shows what are the busiest hours.

For example column A lists the following times (in 24 hour format)
7:57
9:55
11:16
11:24
11:32
12:13
12:25
12:50
13:09
13:33

I want to be able to plot something that returns from 7:00 - 7:59 there
was 1 hit, from 9:00 - 9:59 there was 1 hit, from 11:00 - 11:59 there
were 3 hits, from 12:00 - 12:59 there were 3 hits, and from 13:00 -
13:59 there were 2 hits.

Thanks in advance!


--
trebor18
------------------------------------------------------------------------
trebor18's Profile: http://www.excelforum.com/member.php...o&userid=28187
View this thread: http://www.excelforum.com/showthread...hreadid=477181