Forum Discussion

Hilton Siqueira's avatar
Hilton Siqueira
Copper Contributor
Mar 14, 2018
Solved

Histogram chart is missing from my ribbon menu

Please some help to load histogram chart (and other) to my ribbon menu.   Thanks.   Hilton.
Charts & Visualizing Data
Excel Desktop
  • Jamil's avatar
    Jamil
    Mar 16, 2018

    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

Jamil's avatar
Jamil
Bronze Contributor
Mar 16, 2018

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

Rolf Lange's avatar
Rolf Lange
Copper Contributor
Apr 18, 2018

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?

 

 

Resources