Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
3-D Frequency Chart in VBA | Charts and Charting in Excel | |||
Combine FREQUENCY and SUM of Associated Values | Excel Worksheet Functions | |||
Frequency function | Excel Discussion (Misc queries) | |||
Frequency formula | Excel Worksheet Functions | |||
Frequency for Histograms in Excel | Charts and Charting in Excel |