Forum Discussion
How to change bin number/width in a histogram in Excel for Mac (Office 2020)
Hello, I have created a histogram and now I want to modify the width and number of the bins. Can someone please advise? When I select 'format axis' there is no option to modify bin (see attached). ...
LucaPellegrini just to clarify, in Office 365 select the number of bins, bin width, etc., under FORMAT AXIS > AXIS OPTIONS > bin width, etc. Click on the AXIS for the menu to appear on the right.
This worked for me! Thank you!
It would be great if the help told you this. would have saved me about 2 hours rpill99
