![how to limit bins for histogram in excel 2016 how to limit bins for histogram in excel 2016](https://i.ytimg.com/vi/zmqV-StBxNA/maxresdefault.jpg)
This will instantly add the “Data Analysis” button into the Data Tab.Now from the add-in window, tick mark “Analysis Tool Pack” and click OK.First of all, go to Tool Menu and click on “Excel Add-Ins”.
![how to limit bins for histogram in excel 2016 how to limit bins for histogram in excel 2016](https://www.exceltip.com/wp-content/uploads/2014/11/Histogram.png)
Activating “Analysis Tool Pack” in Excel Macįollow these simple steps to activate “Analysis Tool Pack” in Excel Mac …make sure to download this sample file to follow along. To create a histogram in the Mac version of Excel we need to install “Analysis Tool Pack” as well.