How to Make a Histogram in Excel 2016

Excel 2016 has a histogram maker that’s especially easy to use, as it’s one of the built-in charts available. 

How to Create a Histogram in Excel 2013, 2010, or 2007

Excel 2013 or earlier requires the Analysis ToolPak add-in to use the histogram tool. Make sure it’s installed before you create a histogram in Excel. Once you’ve added the Analysis ToolPak, you can access it in the Analysis group under the Data tab. 

Create a Histogram in Excel 2016 for Mac

You can easily create a histogram in Excel 2016 for Mac after installing the Analysis ToolPak. Once you’ve installed the add-in, you can create a histogram:

What is a Histogram?

Histograms look a lot like other bar charts, but they group numbers into ranges based on your determinations. Compared to other types of graphs, histograms make it easier to identify different data as well as categories and frequencies of occurrence.