How to change bin number/width in a histogram in Excel for Mac (Office 2020)

%3CLINGO-SUB%20id%3D%22lingo-sub-1698641%22%20slang%3D%22en-US%22%3EHow%20to%20change%20bin%20number%2Fwidth%20in%20a%20histogram%20in%20Excel%20for%20Mac%20(Office%202020)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1698641%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20created%20a%20histogram%20and%20now%20I%20want%20to%20modify%20the%20width%20and%20number%20of%20the%20bins.%20Can%20someone%20please%20advise%3F%20When%20I%20select%20'format%20axis'%20there%20is%20no%20option%20to%20modify%20bin%20(see%20attached).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20seen%20various%20videos%20and%20web%20pages%20that%20show%20how%20to%20do%20this%20in%20Excel%202016%20and%20later%2C%20so%20I%20am%20confused%20as%20to%20why%20bin%20width%2Fnumber%20is%20apparently%20hard%20wired%20in%20my%20Excel%20(2020%20Microsoft%20365%2C%20Excel%20version%2016.41).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1698641%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1698853%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20bin%20number%2Fwidth%20in%20a%20histogram%20in%20Excel%20for%20Mac%20(Office%202020)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1698853%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F803102%22%20target%3D%22_blank%22%3E%40LucaPellegrini%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFound%20the%20answer%3A%20Select%20your%20histogram%20chart%20by%20clicking%20on%20one%20of%20the%20bins.%20The%20options%20to%20modify%20the%20bins%20will%20be%20available%20under%20the%20histogram%20tab%20in%20the%20Format%20Data%20Series%20panel%20on%20the%20right.%20So%20nothing%20to%20do%20with%20'Format%20axis'...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps%20someone%20with%20the%20same%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELuca%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2199196%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20bin%20number%2Fwidth%20in%20a%20histogram%20in%20Excel%20for%20Mac%20(Office%202020)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2199196%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F803102%22%20target%3D%22_blank%22%3E%40LucaPellegrini%3C%2FA%3E%26nbsp%3Bjust%20to%20clarify%2C%20in%20Office%20365%20select%20the%20number%20of%20bins%2C%20bin%20width%2C%20etc.%2C%20under%20FORMAT%20AXIS%20%26gt%3B%20AXIS%20OPTIONS%20%26gt%3B%20bin%20width%2C%20etc.%20Click%20on%20the%20AXIS%20for%20the%20menu%20to%20appear%20on%20the%20right.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2203512%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20bin%20number%2Fwidth%20in%20a%20histogram%20in%20Excel%20for%20Mac%20(Office%202020)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2203512%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F992949%22%20target%3D%22_blank%22%3E%40Echeban%3C%2FA%3E%26nbsp%3BHI%20Ethen.%20I%20saw%20the%20pic%20you%20uploaded.%20But%20I%20still%20can't%20find%20where%20to%20modify%20'bin%20width'%20under%20the%20tab%20'Axis%20Options'.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22KaiChang_0-1615497146506.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F262906iF2153FD45D77E669%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22KaiChang_0-1615497146506.png%22%20alt%3D%22KaiChang_0-1615497146506.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 have seen various videos and web pages that show how to do this in Excel 2016 and later, so I am confused as to why bin width/number is apparently hard wired in my Excel (2020 Microsoft 365, Excel version 16.41).

 

Thank you for your help. 

7 Replies

@LucaPellegrini 

Found the answer: Select your histogram chart by clicking on one of the bins. The options to modify the bins will be available under the histogram tab in the Format Data Series panel on the right. So nothing to do with 'Format axis'...

 

Hope this helps someone with the same question.

 

Luca

@LucaPellegrini just to clarify, in Office 365 select the number of bins, bin width, etc., under FORMAT AXIS > AXIS OPTIONS > bin width, etc. Click on the AXIS for the menu to appear on the right. 

@Echeban HI Ethen. I saw the pic you uploaded. But I still can't find where to modify 'bin width' under the tab 'Axis Options'. 

KaiChang_0-1615497146506.png

 

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. 

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

Oh nevermind. I saved it, closed out, reopened and there it is.
/sigh
As Ruthbain says below, my bin width option will not appear. Any suggestions? I've tried saving the chart, closing, and re-entering Excel.