Creating a HIstogram with the Data Analysis Toolpak From the Data Analysis dialog box, click on Histogram.From the Analyze group, we need to select Data Analysis.Next, we need to go to the Data tab on the ribbon.To do that we need to group the ages by two years in cells C2:C5.

To create the previous frequency histogram in Excel using the Data Analysis Toolpak: We need to access it from the Data tab in the Analysis group. Next, we need to select the Analysis Toolpak from the Add-ins box and click OK.We need to click on the Excel Add-ins.From the Excel Options box, we need to click Add-ins from the navigation pane.We need to Click the File tab in the ribbon.It allows us to create a histogram using the data as inputs. First, we need to install the Data Analysis Toolpak. Example of Modifying the Looks of the Histogram Creating a Histogram Using Data Analysis Toolpakįor versions prior to Excel 2016, we have to use the Data Analysis Toolpak to create a histogram. This can be done by changing the title, gridlines, colors, etc. We can also customize the looks of the histogram.The Underflow Bin groups together values that are lower than a certain value.įigure 11. The Overflow Bin clubs together values that are higher than a certain value.įigure 10. We can also use the Overflow and Underflow Bin options to further modify the histogram.This will show the histogram with 5 bins.įigure 9. To make the histogram have 5 bins, we need to go to step 2 and set the Number of Bins to 5. We can also change the number of bins of a histogram in excel.This will make the frequency of ages in a group increased by 2 at each iteration.įigure 8. The bin width specifies how big the bin needs to be. Then, we have to click on the Axis Options and set the Bin Width to 2.Right click on the vertical axis and select Format Axis.To make the histogram show the frequency of an age group of two years, we need to: We can make changes to this histogram and cater it to our own requirements.

This will create a histogram for all the ages.įigure 5.

In the Charts section, we have to click on Insert Statistic Chart.įigure 3.

To create a histogram representing the frequency of ages in Excel 2016 and later versions, we need to: The Sample Student Information Data Set How to Make a Histogram in Excel 2016

Columns A and B have the names and ages respectively.įigure 2. In this example, we will be using a student information database. To create a histogram in Excel Mac, we need to follow different procedures. For previous versions, we need to use the Data Analysis Toolpakck. We can make histograms in Excel 2016 and later versions using the built-in chart option. In this tutorial, we will learn how to create a histogram in Excel. It organizes a series of data by taking several points among the data and groups them into ranges known as bins. We can visually represent insights in Excel using a histogram. How to Create a Histogram in Google Sheets and Excel

How to make histogram in excel 2016