SOLVED
Home

Histogram chart is missing from my ribbon menu

%3CLINGO-SUB%20id%3D%22lingo-sub-171570%22%20slang%3D%22en-US%22%3EHistogram%20chart%20is%20missing%20from%20my%20ribbon%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-171570%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20some%20help%20to%20load%20histogram%20chart%20(and%20other)%20to%20my%20ribbon%20menu.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHilton.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-171570%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-184350%22%20slang%3D%22en-US%22%3ERe%3A%20Histogram%20chart%20is%20missing%20from%20my%20ribbon%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-184350%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20loaded%20the%20Analysis%20ToolPak%2C%20have%20entered%20my%20data%20(and%20bins)%20into%20an%20Excel%20worksheet.%26nbsp%3B%20When%20I%20go%20to%3A%20Data%26gt%3BData%20Analysis%26gt%3BHistogram%20and%20enter%20the%20chart%20output%20option%2C%20I%20get%20a%20one-tailed%20distribution.%26nbsp%3B%20I'm%20trying%20to%20get%20a%20visual%20of%20normality%20(bell%20curve).%26nbsp%3B%20what%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-172798%22%20slang%3D%22en-US%22%3ERe%3A%20Histogram%20chart%20is%20missing%20from%20my%20ribbon%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-172798%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20welcome.%20Thanks%20for%20the%20feedback%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-172754%22%20slang%3D%22en-US%22%3ERe%3A%20Histogram%20chart%20is%20missing%20from%20my%20ribbon%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-172754%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jamil%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20for%20your%20help.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20had%20some%20updates%20yesterday%20and%20now%20my%20Ribbon%20on%20Excel%202016%20shows%20the%20Histogram%20Chart.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20a%20lot.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHilton.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-172670%22%20slang%3D%22en-US%22%3ERe%3A%20Histogram%20chart%20is%20missing%20from%20my%20ribbon%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-172670%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Hilton%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHistogram%20built-in%20chart%20is%20only%20available%20in%20Excel%202016%20and%20365.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ebut%20if%20you%20have%20older%20version%20of%20Excel%20then%20you%20can%20also%20use%20the%20default%20add-in%20of%20Analysis%20tool%20pack%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethe%26nbsp%3Banimated%20image%20below%20shows%20how%20to%20find%20the%20built-in%20histogram%20chart%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eand%20if%20you%20want%20to%20find%20out%20how%20you%20can%20get%20the%20analysis%20tool%20pack%20in%20your%20ribbon%20then%20please%20see%20the%20Microsoft%20support%20page%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F214269%2Fhow-to-use-the-histogram-tool-in-excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F214269%2Fhow-to-use-the-histogram-tool-in-excel%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fgifyu.com%2Fimage%2FsKJR%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fs1.gifyu.com%2Fimages%2FUntitled-Project147dbedbadbbbade.gif%22%20border%3D%220%22%20alt%3D%22Untitled-Project147dbedbadbbbade.gif%22%20%2F%3E%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Please some help to load histogram chart (and other) to my ribbon menu.

 

Thanks.

 

Hilton.

4 Replies
Highlighted
Solution

Hi Hilton,

 

Histogram built-in chart is only available in Excel 2016 and 365.

 

but if you have older version of Excel then you can also use the default add-in of Analysis tool pack

 

the animated image below shows how to find the built-in histogram chart 

 

and if you want to find out how you can get the analysis tool pack in your ribbon then please see the Microsoft support page https://support.microsoft.com/en-us/help/214269/how-to-use-the-histogram-tool-in-excel

 

 

 

 

 

Untitled-Project147dbedbadbbbade.gif

Highlighted

Hi Jamil,

 

Thanks for your help.

 

I had some updates yesterday and now my Ribbon on Excel 2016 shows the Histogram Chart.

 

Thanks a lot.

 

Hilton.

Highlighted

You are welcome. Thanks for the feedback

Highlighted

I have loaded the Analysis ToolPak, have entered my data (and bins) into an Excel worksheet.  When I go to: Data>Data Analysis>Histogram and enter the chart output option, I get a one-tailed distribution.  I'm trying to get a visual of normality (bell curve).  what am I doing wrong?