With a continuous set of data**, histograms** show the shape of a frequency distribution. A histogram aids in the analysis of data graphically for many different applications. A bar chart compares two variables (X and Y), whereas a histogram only analyzes one variable. This is how a histogram varies from a bar chart. You need to get a data set and a sense of how you will bin those values in order to be able to generate a histogram. In this article, we will show you how to make a histogram using the analysis toolpak.

## Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.

## Histogram in Excel

A histogram is a visual depiction that arranges a number of data points into user-specified intervals and is structurally identical to a bar chart. The histogram groups several data points into logical ranges or bins in order to reduce a data series into a widely comprehensible graphic.

## Step-by-Step Procedures to Make Histogram Using Analysis ToolPak

You can visually summarize your data with diagrams and graphs. The officials will run through your study if you merely submit a draft with a few key findings. Therefore, extensive charts, graphs, and other visualization techniques are used to generate database and Excel dashboards. In the following steps, we will demonstrate a particular type of bar chart called a histogram, and how to make a histogram using the analysis toolpak. Let’s suppose we have a sample data set.

### Step 1: Setting Up Analysis ToolPak

Let’s now demonstrate how to **create a histogram** utilizing this data using the Data Analysis ToolPak. You will find a command called** Data Analysis** in the **Analysis **set of commands under the **Data **tab. . So, at the start of this section, we will set up the** Analysis ToolPak **in **Excel**.

- Here, go to the
tab*File**.*

- Firstly, select the
tab from the*Add-ins*dialog box.**Excel Options** - Secondly, choose the
from the**Analysis ToolPak**.**Inactive Application Add-ins** - Besides, you can now select
from the**Excel Add-ins**drop-down menu.*Manage* - Now, click on the
option.**Go…**

- Here, an
dialog box will appear.**Add-ins** - Then, choose the
from the**Analysis ToolPak**.**Add-ins available** - And, click
.*OK* - You will now get the
command in the**Data Analysis**tab’s*Data*set of commands.*Analysis*

**Read More:** **How to Make a Stacked Histogram in Excel (3 Easy Methods)**

### Step 2: Showing Frequency Table

The list has a total of **18 **values. And the range is between **18 **and **65**. So I’ll use bin size **20 **to create the bins. My first bin will therefore range from **0 **to **20**, and I enter the top value of the bin, which is **20, **into cell ** C5**.

**Data Analysis TookPak**requires only the upper value of the bin when making a histogram chart. Then, I put the number

**30**in cell

**because the next bin has a value greater than**

*C6***20**and less than or equal to

**30**. I then place the

**6**upper values in the bins by selecting all the bins for the

**18**values in the dataset.

- At the start of this section, you will see our data table to show the frequency of the data table.

- Now, click on the
tab first.*Data* - Then, click on the
from the**Data Analysis**group*Analysis***.**

- Here, a
dialog box will appear to you.**Data Analysis** - Now, select the
tools.*Histogram* - Then, click
.**OK**

- Firstly, select the
from the above data table.**Input Range** - Secondly, enter the
from the above data table.**Bin Range** - Thirdly, you can choose any cell for the
. Here we choose the**Output Range**cell.*E4* - Now, click
.*OK*

- Finally, you will see the frequency table here.

**Read More: ****How to Change Bin Range in Excel Histogram (with Quick Steps)**

### Step 3: Utilizing Analysis ToolPak to Make Histogram

In this section, we will create a **Histogram** utilizing the** Analysis ToolPak **from the** Data **tab**. **At first, we will discuss several features that are important to creating a **Histogram**.

**Input Range**

It is necessary to enter all the information for the histogram. The data set’s range is the input range.

**Bin Range**

These basically specify what is put into each bar. Care should be taken when choosing these bins. Select the range of bins to input, making sure that the range is in increasing order.

**Labels**

Only if the data ranges are chosen along with the data set header and bin data, should this box be checked.

**Print Options**

Where the histogram prints are regulated by these options. By naming a new worksheet, selecting a range in the present worksheet, or choosing a new workbook, the output can be printed.

**Print Output Options**

What data is shown depends on these choices. If you need to examine the data in a certain way, you might take a look at these possibilities.

- Here, you will see our data table used to make the data table’s histogram at the beginning of this section.

- Now, navigate to the
tab first.*Data* - Then, click on the
from the**Data Analysis**group.*Analysis*

- Here, you will see a
dialog box.**Data Analysis** - Now, choose the
tool.**Histogram** - Then, click
.*OK*

- First, pick an
from the data table above.**Input Range** - Next, enter the
from the data table mentioned above.**Bin Range** - Thirdly, choose the
to see the histogram in another worksheet.**New Worksheet Ply** - After that, choose the
option.**Chart Output** - Finally, click
.*OK*

- Consequently, you will observe the final histogram bar chart in the below image with the frequency table.
- Here, you will see that we receive
**two**values between**0**and**20**,**six**values between**20**and**30**,**four**values between**30**and**40**, and so forth. The figure makes it obvious that there is no pattern in the data. In**data analysis, the histogram**graphic is a key idea. This method will be helpful to you once you understand how to make a**Bell Curve**in Excel.

**Read More: What Is Bin Range in Excel Histogram? (Uses & Applications)**

## Conclusion

In this article, I’ve covered the step-by-step process of how to make a **histogram **using **Analysis ToolPak**. I sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on **Excel**, you may visit our website, **Exceldemy**. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.