Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I created a histogram using the FREQUENCY function for a dataset I'm working
with. As I was thinking things over, I'd like to see how the frequencies "built up" over the period of time that the data was collected. The catch is that I want my bins to go horizontal and the freqs to be able to be pulled down vertically, like so: 10 20 30 40 50 60 <--Bins Date1 1 0 1 1 0 1 Date2 2 1 1 1 0 2 Date3 2 2 1 1 0 2 Date4 2 3 1 1 0 2 Date5 2 3 2 2 1 2 Date6 2 3 2 2 1 2 ....and so forth. I've had trouble getting FREQUENCY recognizing the bins properly when organizing the table like the one above (I want it this way to line up with the dataset that I have); the closest I've gotten is having it decide all the bins are from the limit provided to 0 (so, instead of 0 to 10, 11 to 20; it's 0 to 10, 0 to 20). There's probably another way of doing this without using FREQUENCY, but I'd thought I'd ask those who may have wanted to tweak it like this before. Thanks yet again! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Easy Sorting Question | Excel Discussion (Misc queries) | |||
Elapsed time question | Excel Discussion (Misc queries) | |||
Easy question? Page numbers | Excel Discussion (Misc queries) | |||
Formula TIME question | Excel Discussion (Misc queries) | |||
merging columns - one date, one time | Excel Worksheet Functions |