How To Create Bin Width In Excel?
Question
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Lorem ipsum dolor sit amet, consectetur adipiscing elit.Morbi adipiscing gravdio, sit amet suscipit risus ultrices eu.Fusce viverra neque at purus laoreet consequa.Vivamus vulputate posuere nisl quis consequat.
Answers ( 3 )
In Excel, how do I alter the bin width?
Bin width can be changed by right-clicking the histogram’s horizontal axis and selecting Format Axis from the context menu: To begin with, what is this? You can see that Excel set the bin width to 30,000 in the window that opens up to the right. Let’s set it to whatever we want.
To do this, right-click on the horizontal axis and choose “Format Axis” from the menu that appears. Similar to what happened before, this will open a window on the right side of your screen. To change the width of the bin, change the number next to “Bin width” to the number you want and press Enter.