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). ...
I figured it out!!!!!! Okay so Select the Actual Data Series (The bars in the histogram), and it'll give you an option to format it. From there you can adjust the bins! -There's also a tutorial on youtube that shows how to do it. https://www.youtube.com/watch?v=wmCIEwKO5no