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

Sep 18, 2021

As Ruthbain says below, my bin width option will not appear. Any suggestions? I've tried saving the chart, closing, and re-entering Excel.

Lcwkee

Copper Contributor

Sep 19, 2021

vantonich lmao, the assignment is due tmr and we're both at a lost. I cant find the solution anywhere.