Forum Discussion

Copper Contributor

Sep 22, 2020

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). ...

Copper Contributor

Jul 08, 2021

PaoWaLee

I still do not have the option to adjust my chart's bins to what I want. I do not get the window at all. I have Microsoft 365. I've looked all over the internet for 2 hours.

365Excelnobinadjustment.docx546 KB

Ruthbain

Copper Contributor

Jul 08, 2021

Oh nevermind. I saved it, closed out, reopened and there it is.
/sigh