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

1 Reply

@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