Forum Discussion
LucaPellegrini
Sep 22, 2020Copper Contributor
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). ...
Bestie90
Mar 23, 2022Copper Contributor
I was struggling with this today and it turned out I had actually selected a column chart, not a histogram, which was why the bin options weren't displaying. Hoping that leaving this comment saves someone else the same frustration...