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 On Excel for the Mac, right-click (mouse) or two-finger click (track pad) on the data series inside the chart and choose "Format Data Series..." You'll find the BIN settings in the Options tab, in contrast to Excel for Windows where the BIN settings are part of "Format Axis..."