Home

Changing bin labels in histogram

%3CLINGO-SUB%20id%3D%22lingo-sub-354197%22%20slang%3D%22en-US%22%3EChanging%20bin%20labels%20in%20histogram%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354197%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can't%20seem%20to%20figure%20out%20how%20to%20change%20the%20bin%20label%20display%20on%20the%20histogram%20I%20created%20using%20the%20Excel%202016%20histogram%20chart%20function.%20Right%20now%20the%20bin%20labels%20show%20up%20as%20ranges%20with%20parentheses%20-%20(0%2C5%5D%2C%20(5%2C10%5D%2C%20(10-15%5D%2C%20etc.%20I'd%20prefer%20to%20display%20individual%20numbers%20at%20the%20dividing%20point%20between%20bins%20(i.e.%205%2C%2010%2C%2015%2C%2020)%2C%20rather%20than%20numeric%20ranges%2C%20but%20all%20I%20see%20under%20axis%20options%20is%20how%20to%20adjust%20the%20number%20or%20width%20of%20bins%2C%20but%20no%20options%20for%20changing%20how%20the%20bin%20labels%20are%20displayed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20if%20there's%20a%20way%20to%20do%20this%3F%20I'm%20attaching%20the%20histogram%20I've%20got%20so%20far%20for%20reference.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-354197%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
apheinz
Occasional Visitor

I can't seem to figure out how to change the bin label display on the histogram I created using the Excel 2016 histogram chart function. Right now the bin labels show up as ranges with parentheses - (0,5], (5,10], (10-15], etc. I'd prefer to display individual numbers at the dividing point between bins (i.e. 5, 10, 15, 20), rather than numeric ranges, but all I see under axis options is how to adjust the number or width of bins, but no options for changing how the bin labels are displayed.

 

Does anyone know if there's a way to do this? I'm attaching the histogram I've got so far for reference.

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies