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

Mar 20, 2021

Hi, LucaPellegrini , I just figure it out.

1. Right-click on your data area

2. Select format data series

3. Select options

4. Select bin width from the drop-down menu

I hope it works for you.

vantonich

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.