After you have added the Analysis ToolPak to your Excel software, you will find it on the Data tab. Click on Data and then Data Analysis. You can now complete a number of advanced data analysis tasks ...

Use Data Analysis Toolpak: Excel’s Data Analysis Toolpak offers a built-in histogram tool that can simplify the process. Make sure to enable it from the Add-ins menu.