Resolved: How to display the endpoint of a histogram interval?
I can't figure out how to display the endpoint of a histogram interval on the X-axis. I'm using Excel 2021.
For example the exercise solution shows it but mine doesn't it. I tried going into "Format Axis" but don't know where to change.
thanks for reaching out! To be able to see the endpoints of the intervals you can try and:
extend the chart to the right, to allow more space for the intervals to be shown, this is probably why you're not seeing them at the moment.
Alternatively, you can:
- open the format Axis menu
-click on the Number option
-scroll down to Decimal places and change it from 2 to 0.
In this case, you don't really need the actual decimal places here, so the graphic actually looks cleaner and easier to interpret without the decimal points.
Hope this helps!