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
  - Riny_van_Eekelen
    Platinum Contributor
    Jun 07, 2020
    Pier_The_Excelman You should right-click on any of the blue columns in the graph and select the bottom option "Format Data Series" (in English). Your picture indicates you clicked on "Select Date" in the Chart Design ribbon.