We can visually represent insights in Excel using a histogram. It organizes a series of data by taking several points among the data and groups them into ranges known as bins. In this tutorial, we will learn how to create a histogram in Excel. Show
We can make histograms in Excel 2016 and later versions using the built-in chart option. For previous versions, we need to use the Data Analysis Toolpakck. To create a histogram in Excel Mac, we need to follow different procedures. How to Create an Excel Histogram ChartIn this example, we will be using a student information database. Columns A and B have the names and ages respectively.
How to Make a Histogram in Excel 2016To create a histogram representing the frequency of ages in Excel 2016 and later versions, we need to:
This will create a histogram for all the ages.
We can make changes to this histogram and cater it to our own requirements. To make the histogram show the frequency of an age group of two years, we need to:
This will make the frequency of ages in a group increased by 2 at each iteration.
The Underflow Bin groups together values that are lower than a certain value.
Creating a Histogram Using Data Analysis ToolpakFor versions prior to Excel 2016, we have to use the Data Analysis Toolpakto create a histogram. First, we need to install the Data Analysis Toolpak. It allows us to create a histogram using the data as inputs. To do that,
This will install the Analysis Toolpak. We need to access it from the Data tab in the Analysis group. To create the previous frequency histogram in Excel using the Data Analysis Toolpak:
This would insert the histogram with the frequency distribution in the specified location.
How to Make a Histogram in Excel MacTo create the histogram from the previous example in Mac, we need to:
Creating a Histogram in Google SheetsWe can create a histogram in Google sheets by calculating the normal distribution. To create the histogram from the previous example, we need to:
We can customize the bin sizes. To do that, we need to go to the Customize tab from the Chart Editor. Here, we can change the Bucket Size to 2.
This will create the same histogram as before in Google Sheets. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes. |