Forum Discussion

Copper Contributor

Jun 06, 2020

histogram for a frequency

Good Morning, in my worksheet I have a series of numbers of which I have successively calculated their frequency in a series of intervals, but then I wanted to create the graph, in which in the ordin...

Excel on Mac

Riny_van_Eekelen

Platinum Contributor

Jun 07, 2020

Pier_The_Excelman Perhaps the attached workbook can point you in the right direction. It contains a histogram of a list of random numbers between 18.2 and 18.9, just like in your example, where each bin spans an interval of 0.1.

pier.xlsx13 KB

Pier_The_Excelman
Copper Contributor
Jun 07, 2020
Sorry to bother you, but do you know how to do more than three intervals? Riny_van_Eekelen
- Riny_van_Eekelen
  Platinum Contributor
  Jun 07, 2020
  Pier_The_Excelman No problem! I guess that the histogram defaults to three bins in your case. Right-click on the data series and select "Format Data Series...". Here you can specify the bin settings. Set "Bins" to Bin width (i.e. not Auto) and set "Bin width" to 0.1 to set your interval.
  - Pier_The_Excelman
    Copper Contributor
    Jun 07, 2020
    iI don't know why it's different., I'm quite pretty sure it's the latest versionRiny_van_Eekelen
Pier_The_Excelman
Copper Contributor
Jun 07, 2020
Riny_van_Eekelen amazing, thank you very much!