Share via

No option to change histogram bin sizes

Anonymous
2022-07-06T08:22:16+00:00

I've been trying to change the bin sizes for my histogram, but for some reason, I can't find an option to do so. I selected the horizontal axis, right-clicked on format axis and navigated to axis options, but there is no bins section as can be seen in the image. Any advice?

*** Moved from Windows / Windows 10 / Performance and system failures ***

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Reported
    Anonymous
    2022-07-07T05:19:06+00:00

    Dear Miss M Bester,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

    It seems that you have created a histogram and you want to modify the width and number of the bins. When you select 'format axis' there is no option to modify bin size.

     In Excel for Windows the BIN settings are part of "Format Axis..." And On Excel for the Mac, I believe the bins will be available under the histogram tab in the Format Data Series panel on the right (the bins came up under "Format Data Series".). not in 'Format axis'. Right-click on the data series inside the chart and choose "Format Data Series..."  You'll find the BIN settings in the Options tab.

    Excel for Mac OS:

    Excel for Windows OS:

    Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

    Sincerely,

    Waqas Muhammad

    ***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-07-08T06:15:26+00:00

    Thank you very much. This is very helpful!

    1 person found this answer helpful.
    0 comments