Forum Discussion

Copper Contributor

Nov 07, 2021

Constructing Frequency Distribution Histogram as shown in my textbook

Dear Excel Community, I hope you are doing well. I need help in constructing a histogram in the same theme (format) as shown in my textbook (attached image). Kindly, help me by providing steps if...

Brass Contributor

Nov 12, 2021

Hi mohdt21

I attached a sample chart. Data refresh in chart automatically as you change your data selection.

You can check here for https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr.

And if you are comfortable with Google Sheets, you can find https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr.

Thanks

mohdt21
Copper Contributor
Nov 13, 2021
Hi Qaiser_j,

Thank you for your help, you did a great job. However, I need the bars in the histogram to touch each other as instructed by my textbook. And if I did that there will be no space as shown in the image above on the onset of the first bar so how to overcome this!

I have also noticed that you used the class i.e., 30-39 for each bar label instead of using just number boundaries as in my textbooks.

I wish you would help me fix that.
- PeterBartholomew1
  Silver Contributor
  Nov 13, 2021
  mohdt21
  You seem to be concerned about presentational detail. I chose to use a column chart in preference to the statistical chart with bin labels. Excel is not a graphic art package but it does offer a fair level of control through formatting.
  - mohdt21
    Copper Contributor
    Nov 13, 2021
    Advise me which software will work the best with statistical alongside graphical art ?!