Share via

Histogram Bin Labeling Issue

Anonymous
2024-02-18T03:29:41+00:00

I want my bins on a histogram labeled with just one number, not two. For example, with a data set with values from 1-10 and bin width 1, excel labels the first bin (1,2), then (2,3) and so on. I just want them labeled 1, 2, etc...

How do I do this?

Microsoft 365 and Office | Excel | For business | 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. riny 20,870 Reputation points Volunteer Moderator
    2024-02-18T06:23:16+00:00

    I believe that's by design and you can't change that. Histogram are meant to show the bucket [from value, up to but not including value]. If your values are whole numbers between 1 and 10 I'd suggest you create a regular clustered column chart with a small gap width and adjustable axis labels. Use COUNTIF to count the number of occurrences of each number. If you have decimal numbers between 1 and 10.9999 you could round them down first (i.e. take their integer values) in a helper column and then use COUNTIF on those.

    2 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest