Hi, 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. Thank you.

Hi Quang, 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! Best, 365 Eli

Thank you. Both of the things you mentioned worked!

Follow this topic

Quang Nguyen

Last answered:

01 Feb 2022

Posted on:

29 Jan 2022

Resolved: How to display the endpoint of a histogram interval?

in Statistics / Practical Example - Descriptive Statistics

2 answers ( 1 marked as helpful)

Elitsa Kaloyanova

Instructor

Posted on:

01 Feb 2022

Helpful answer

Quang Nguyen

Posted on:

01 Feb 2022

Resolved: How to display the endpoint of a histogram interval?

Submit an answer

related questions