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 I use Excel for Mac, and I came across the same issue of not being able to change the bins, as that option was not seen when clicking the Format Axis tab. So the solution to this, which I accidentally discovered, is that if you right-click on the histogram bars, select Format Data Series... Now you will get a window open with the option to change the bins. Select Format Data SeriesChange Bins