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

Frequency plotting
 

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.

trebor18 Wrote:
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


--
jahoobob