Changing bin labels in histogram

Copper Contributor

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.

0 Replies