histogram for a frequency

%3CLINGO-SUB%20id%3D%22lingo-sub-1445504%22%20slang%3D%22en-US%22%3Ehistogram%20for%20a%20frequency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445504%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%2C%26nbsp%3Bin%20my%20worksheet%20I%20have%20a%20series%20of%20numbers%20of%20which%20I%20have%20successively%20calculated%20their%20frequency%20in%20a%20series%20of%20intervals%2C%20but%20then%20I%20wanted%20to%20create%20the%20graph%2C%20in%20which%20in%20the%20ordinates%20I%20would%20have%20put%20the%20numbers%20from%201%20to%2010%2C%20while%20in%20the%20abscissas%20I%20would%20have%20put%20the%20numbers%20that%20I%20had%20previously%20found%2C%20only%20that%20when%20I%20select%20the%20data%20I%20can't%20understand%20how%20to%20go%20on%2C%20below%20I%20leave%20the%20photo%20of%20my%20worksheet%2C%20thanks%20for%20the%20answers%3C%2FP%3E%3CP%3Epier%3C%2FP%3E%3CP%3E(p.s.%20sorry%20for%20my%20English)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1445504%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445941%22%20slang%3D%22en-US%22%3ERe%3A%20histogram%20for%20a%20frequency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445941%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F691087%22%20target%3D%22_blank%22%3E%40Pier_The_Excelman%3C%2FA%3E%26nbsp%3BPerhaps%20the%20attached%20workbook%20can%20point%20you%20in%20the%20right%20direction.%20It%20contains%20a%20histogram%20of%20a%20list%20of%20random%20numbers%20between%2018.2%20and%2018.9%2C%20just%20like%20in%20your%20example%2C%20where%20each%20bin%20spans%20an%20interval%20of%200.1.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1446063%22%20slang%3D%22en-US%22%3ERe%3A%20histogram%20for%20a%20frequency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1446063%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bamazing%2C%20thank%20you%20very%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1446105%22%20slang%3D%22en-US%22%3ERe%3A%20histogram%20for%20a%20frequency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1446105%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20to%20bother%20you%2C%20but%20do%20you%20know%20how%20to%20do%20more%20than%20three%20intervals%3F%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1446112%22%20slang%3D%22en-US%22%3ERe%3A%20histogram%20for%20a%20frequency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1446112%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F691087%22%20target%3D%22_blank%22%3E%40Pier_The_Excelman%3C%2FA%3E%26nbsp%3BNo%20problem!%20I%20guess%20that%20the%20histogram%20defaults%20to%20three%20bins%20in%20your%20case.%20Right-click%20on%20the%20data%20series%20and%20select%20%22Format%20Data%20Series...%22.%20Here%20you%20can%20specify%20the%20bin%20settings.%20Set%20%22Bins%22%20to%20Bin%20width%20(i.e.%20not%20Auto)%20and%20set%20%22Bin%20width%22%20to%200.1%20to%20set%20your%20interval.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-06-07%20at%2012.36.42.png%22%20style%3D%22width%3A%20253px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197081iFFE7175E730D25DE%2Fimage-dimensions%2F253x243%3Fv%3D1.0%22%20width%3D%22253%22%20height%3D%22243%22%20title%3D%22Screenshot%202020-06-07%20at%2012.36.42.png%22%20alt%3D%22Screenshot%202020-06-07%20at%2012.36.42.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1446787%22%20slang%3D%22en-US%22%3ERe%3A%20histogram%20for%20a%20frequency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1446787%22%20slang%3D%22en-US%22%3E%3CP%3EiI%26nbsp%3Bdon't%20know%26nbsp%3Bwhy%20it's%20different.%2C%20I'm%20quite%26nbsp%3Bpretty%20sure%20it's%20the%20latest%20version%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Schermata%202020-06-07%20alle%2016.29.00.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197096i7C38A78DF051A1A0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Schermata%202020-06-07%20alle%2016.29.00.png%22%20alt%3D%22Schermata%202020-06-07%20alle%2016.29.00.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1446815%22%20slang%3D%22en-US%22%3ERe%3A%20histogram%20for%20a%20frequency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1446815%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F691087%22%20target%3D%22_blank%22%3E%40Pier_The_Excelman%3C%2FA%3E%26nbsp%3BYou%20should%20right-click%20on%20%3CSTRONG%3Eany%20of%20the%20blue%20columns%3C%2FSTRONG%3E%20in%20the%20graph%20and%20select%20the%20bottom%20option%20%22%3CFONT%20color%3D%22%23FF0000%22%3EFormat%20Data%20Series%3C%2FFONT%3E%22%20(in%20English).%20Your%20picture%20indicates%20you%20clicked%20on%20%22Select%20Date%22%20in%20the%20%26nbsp%3B%20Chart%20Design%20ribbon.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1446850%22%20slang%3D%22en-US%22%3ERe%3A%20histogram%20for%20a%20frequency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1446850%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%20you%20really%20helped%20me%20a%20lot.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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 ordinates I would have put the numbers from 1 to 10, while in the abscissas I would have put the numbers that I had previously found, only that when I select the data I can't understand how to go on, below I leave the photo of my worksheet, thanks for the answers

pier

(p.s. sorry for my English)

7 Replies
Highlighted

@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.

Highlighted

@Riny_van_Eekelen amazing, thank you very much!

Highlighted

Sorry to bother you, but do you know how to do more than three intervals? @Riny_van_Eekelen 

Highlighted

@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.

Screenshot 2020-06-07 at 12.36.42.png

Highlighted

iI don't know why it's different., I'm quite pretty sure it's the latest version@Riny_van_Eekelen 

Schermata 2020-06-07 alle 16.29.00.png

Highlighted

@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.

Highlighted

Thank you! you really helped me a lot.@Riny_van_Eekelen