Mar 14 2018
06:28 AM
- last edited on
Jul 25 2018
09:46 AM
by
TechCommunityAP
Mar 14 2018
06:28 AM
- last edited on
Jul 25 2018
09:46 AM
by
TechCommunityAP
Please some help to load histogram chart (and other) to my ribbon menu.
Thanks.
Hilton.
Mar 16 2018 09:16 AM
SolutionHi 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
Mar 16 2018 11:34 AM
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.
Mar 16 2018 01:39 PM
You are welcome. Thanks for the feedback
Apr 18 2018 10:14 AM
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?
Feb 09 2021 05:39 PM
Hi
Please I need a help on how I can add Histogram chart to my ribbon (Excel) 2013 vision.
I have been for a while now
Reagards
Chris
Mar 16 2018 09:16 AM
SolutionHi 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