Forum Discussion
Can I make custom bins in an Excel histogram?
This is for Excel for Mac, version 16.30. I have a seemingly simple problem: Let's say I have a column of data that consists of: 3, 4, 4, 4, 6, 6 I want to create a simple histogram that has bi...
Does 16.30 allow for the SEQUENCE function? If yes, then you could have your data in a table called tblData and then somewhere place this formula (say in cell C2):
=SEQUENCE(6)
Then in the cell next to C2, enter =FREQUENCY(tblData,C2#)
=SEQUENCE(6)
Then in the cell next to C2, enter =FREQUENCY(tblData,C2#)