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). ...
Found the answer: Select your histogram chart by clicking on one of the bins. The options to modify the bins will be available under the histogram tab in the Format Data Series panel on the right. So nothing to do with 'Format axis'...
Hope this helps someone with the same question.
Luca
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
