Forum Discussion

LucaPellegrini's avatar
LucaPellegrini
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). ...
Charting
Excel on Mac
office 365
PaoWaLee's avatar
PaoWaLee
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's avatar
    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's avatar
      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.

  • Ruthbain's avatar
    Ruthbain
    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.

    • Ruthbain's avatar
      Ruthbain
      Copper Contributor
      Jul 08, 2021
      Oh nevermind. I saved it, closed out, reopened and there it is.
      /sigh

Resources