Last answered:

06 Jan 2022

Posted on:

05 Jan 2022

2

how to include both the interval start and end in the axis's name??? any help!!

image.png

4 answers ( 0 marked as helpful)
Instructor
Posted on:

06 Jan 2022

3

Hello Asmaa!

Thanks for reaching out!

Please try the following sequence of commands. Select the data set that consists of numbers from 13 to 936. Then, press Cntr+Q to access the Quick Analysis Toolpak. Go for the Histogram option under the "Charts" category. Depending on your version of Excel, it might be listed under "Recommended Charts" or "All Charts". Once you create the histogram, please right click on the X-axis and go for "Format Axis". This is where you control the bins. In the exercise's case the number of bins should be 10. You can also try playing with the bins and see how this changes the histogram created.

Hope this helps!

Best,
The 365 Team

Posted on:

06 Jan 2022

0

Thanks a lot for your response, but it partially worked

image.png

Instructor
Posted on:

06 Jan 2022

0

Hello Asmaa!

Thanks for the quick reply!

Please select the data set on the left (not the one on the right side of the picture that you are showing). Here is a reference on what you should select:
image.png

Then, please re-do the trial.

Thanks!

Best,
The 365 Team

Posted on:

06 Jan 2022

0

thanks a lot. it works
image.png

Submit an answer