You'll have to do something to fix the row labels ex, if your bins are size 2, then everything labelled '58' is from the interval [58,60), so replace the row name accordingly. (You could probably also do a pivot chart based on the pivot table, but that gives you less flexibility, and you'd have a problem for #4 below.) 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 did one of these: 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.
