Forum Discussion
Help with histograph
does this make sense? Do I need more detail here?
I am trying to run a histograph for days on market for a subdivision. I want to take all of the data that closed 0-30 and have in one column; 31-60 in another column; 61-90 in a third; 91-120 in a fourth.
the data I need is days on market and closed dates which I have in an excel spreadsheet.
here is example of three. First property closed on 2/22 and was on market 1 day. Second closed on 6/22 and was on market 2 days. Third closed on 4/29 and wasn't on market a day before a contract. This is a sample where the spreadsheet is 125 properties.
| 2/22/22 0:00 | 1 |
| 6/22/22 0:00 | 2 |
| 4/29/22 0:00 | 0 |
any help would be greatly appreciated!! I'm new at this
1 Reply
Read about column charts and binning. That'll give you the histogram you need. Good thing that you have a fixed list of bucket ranges. It would be harder with dynamic bucket sizes.
