Then do a pivot table and drop B in as your rows and D as your columns, and make sure the values is doing a count and not a sum or anything.Ĭopy and paste (by value) your pivot table contents into a new sheet.
Ex, if your variable ranges from 61 to 75 and you want to put it into bins of width 2, then you add a column D with the equation '=FLOOR(B?,2)'. You have to break the data up into bins yourself to do this I suggest using FLOOR.
If, however, you'd like to cluster it by a categorical variable in column C, then you do this: Let's say you have a numerical variable in column B and you want to do a histogram of it, then, sure, highlight column B and insert a histogram. There are a couple of ways to create a clustered/stacked histogram in Excel, but I can only remember one of them right now. The person who answered above misread the question. ) who needs this in future can maybe find it. I know you asked this three years ago, but I'll answer so that anyone (like me.
