Occasionally, you might need to** create a histogram** for data visualization. Basically, a histogram is a column chart that displays how frequently a variable occurs within a given range. Moreover, it is a common tool for data analysis in the corporate world. In this article, I will show you five simple methods to plot histogram in Excel.

**Table of Contents**hide

## Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.

## 5 Easy Ways to Plot Histogram in Excel

Fortunately, there are numerous approaches to making a histogram in Excel. In this part, I will show you five simple methods to plot ** Histogram **in Excel. However, it includes

**,**

*Statistic Chart***,**

*Data Analysis Toolpak***,**

*FREQUENCY function***and**

*COUNTIF function***. For the purpose of demonstration, I have used the following sample dataset.**

*Pivot Chart*### 1. Using Statistic Chart to Plot Histogram in Excel

If you are using Excel 2016 or a later version, you can insert a statistical chart to build a histogram in Excel. Actually, Excel comes with this feature built in. Because the * Histogram *chart will take into account the entire data range and base its result on that. However, follow the steps below to complete the operation.

**Steps:**

- Firstly, you have to select the data.
- Secondly, you have to go to the
tab.**Insert** - Thirdly, from the
**Charts**group section, you have to select theand then select**Insert Statistic Chart**.**Histogram**

- After that, a
will appear, and double-click on the rectangle. So, a new window named*Histogram*will appear beside the worksheet.*Format Data Series* - Increase the
according to your preference from the*Gap Width*.*Series Option*

- Again, double-click on the
values, and a new window named*bins*will appear beside the worksheet.*Format Axis* - Then, from the
, change the*Axis Options*according to your choice.*Bin width* - Also, you may change the
and*Overflow bin*.*Underflow bin*

- Now, click on the
. From the*Histogram*select the mentioned items.*Chart Elements*

- Lastly, you will get your desired
.*Histogram*

**Read More:**** How to Make a Histogram in Excel Using Data Analysis**

### 2. Applying Data Analysis Toolpak for Plotting Histogram

** Data Analysis Toolpak** is one of the best features of Excel when we need to do advanced statistical analysis. In this section, I will show you the quick and easy steps to make a Histogram in Excel using

**.**

*Data Analysis ToolPak**Steps:*

- At first, press
+*ALT*+*F*or select*T*>>*File*. Then go to the*Options*tab and click on*Add-ins*beside*Go*.*Manage: Excel Add-ins*

- Next, check the
checkbox and click*Analysis ToolPak*. After that, you will be able to access the*OK*tool.*Data Analysis*

- Lastly, you will see that there is a new ribbon named
under the*Data Analysis*tab, and click on the*Data*command.*Data Analysis*

- Now, select
and then click on*Histogram*from the dialog box.*OK*

- Here, select the data range for which you want to create a
in the box named*Histogram*. Here, I have selected*Input Range*as the*C5:C15*which contains the marks of*Input Range*.*English* - Then, select the
of the*Bin Range*. In this part, I have selected cells*Histogram*as the*C17:G17*.*Bin Range* - Then, you have to assign a cell as the
where the output chart and frequency table will be created. Hence, I have selected the cells*Output Range*.*F5:G11* - After that, mark the checkbox called
.*Chart Output* - Now, click on
.*OK*

- Finally, you will see the
along with a*Histogram*and*Bin*table as follows. However, the*Frequency*can be changed to make it look better than the*Histogram*as mentioned in the previous method.*Chart Elements*

- However, the final Histogram will be like the following picture.

**Read More:** **How to Make Histogram Using Analysis ToolPak (with Easy Steps)**

### 3. Using FREQUENCY Function to Plot Histogram

In this part, you will find a way to create a ** Histogram **using

**. In essence, I’ll use**

*the FREQUENCY function***to get the frequencies, and then I’ll draw a simple bar graph to generate the**

*the FREQUENCY function***. Hence, follow the steps below to be able to do that.**

*Histogram***Steps:**

- Firstly, enter the following formula in cell
. This will return the frequency of data according to the chosen bins.*F6*

` =FREQUENCY(C5:C15,E6:E11)`

**Formula Breakdown**

- In this formula,
will count how many times a value comes within a given interval.*the FREQUENCY function* - Here,
is the data array.*C5:C15* is the Bins array.*F6:F11*- Furthermore, you will get the frequency for more than the value of
also.*F11*

- Next, apply the
tool to apply the function for all the bins.*AutoFill*

- Then select the whole
column and go to the*Frequency*tab.*Insert* - After that, choose
from the*2-D Column Graph*.*charts group of commands*

- Now, select the chart.
- Then, from the
tab, go to the*Chart Design*feature.*Select Data*

- A dialog box will generate. Hence, choose the
option.*Edit*

- Here, change the series name to
and press*English*.*OK*

- Similarly, you should click on the
option to change the*Edit*.*Axis Labels*

- After that, select the
range and click*Axis label*.*OK*

- After this, press
on the*OK*box.*Select Data Source*

- Now, click on the
. From the*Histogram*select the mentioned items.*Chart Elements*

- Lastly, you will get the
in the image below.*Histogram*

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

**Similar Readings**

**How to Make a Histogram in Excel with Two Sets of Data (4 Ways)****[Fixed!] Excel Histogram Bin Range Not Working****How to Create a Bin Range in Excel (3 Easy Methods)**

### 4. Utilizing COUNTIF and COUNTIFS Functions

Moreover, you can use the ** COUNTIF **and

**functions to create a**

*COUNTIFS***. Actually, you have to find out the frequencies with**

*Histogram***and then plot a simple bar graph for creating the**

*the COUNTIF function***. Hence, follow the steps below to complete the operation smoothly.**

*Histogram***Steps:**

- Firstly, enter the following formula in cell
. This will return the frequency of data according to the chosen bins.*F5*

`=COUNTIF($C$5:$C$15,"<=" &E5)`

**Formula Breakdown**

- Here,
will count those cells whose values fulfill a given condition.*the COUNTIF function* - Firstly,
is the range for the lookup array.*$C$5:$C$15* - Secondly,
are the criteria, which means whether the cell values are less than or equal to the*“<=” &E5*cell value or not.*E5* - Finally,
will count those cells whose values are less than or equal to*the COUNTIF function*.*46*

- Secondly, select another empty cell like
and write down the following formula in that cell. Moreover, apply the*F6*tool to apply the function for all the bins.*AutoFill*

`=COUNTIFS($C$5:$C$15,">"&E5,$C$5:$C$15, "<="&E6)`

**Formula Breakdown**

- Here,
will count those cells whose values fulfill a set of conditions.*the COUNTIFS function* - Firstly,
*$C$5:$C$15* - Secondly,
*“>”&E5**E5* - Thirdly,
is the 2nd range for another lookup array.*$C$5:$C$15* - Fourthly,
*“<=”&E6**E6* - Finally,
will count those cells whose values are between*the COUNTIFS function**47*.*56*

- Now select the complete
column and then go to the*Frequency**Insert tab.* - Similarly, choose
from the*2-D Column Graph*.*charts group of commands*

- After that, select the chart.
- Hence, go to the
feature from the*Select Data*tab.*Chart Design*

- After all, choose the
option from the dialog box.*Edit*

- In this part, change the series name to
and press*English*.*OK*

- Again, you have to click on the
option to change the*Edit*.*Axis Labels*

- After this, select the
range and click*Axis label*.*OK*

- Finally, click
on the*OK*box.*Select Data Source*

- Now, from the
select the mentioned items after clicking on the*Chart Elements*.*Histogram*

- Lastly, you will get your desired
in the following image.*Histogram*

### 5. Using PivotChart to Create Histogram

Alternatively, you can insert a ** PivotChart** to modify it to a

**. Moreover, a pivot table is one of the quickest ways to automatically summarize data in Excel. However, follow the steps below in order to create a**

*Histogram***by using a**

*Histogram***.**

*PivotChart***Steps**:

- Firstly, select the
scores (*English*) and go to the*C5:C15*tab.*Insert* - Now, click on
.*PivotChart*

- Furthermore, enter the location for the
and click*PivotChart*. This will insert a*OK*along with a*PivotChart*.*PivotTable*

- Next, drag the
field to the*English*and*Axis*areas.*Values*

- After that, click on
in the*Count of English*area and go to the*Values*.*Value Field Settings*

- In this part, change the type of calculation to
and click*Count*.*OK*

- A
will be generated.*PivotChart*

- After that, right-click on any cell from the
in*Row Labels*and select*the Pivot Table*.*Group*

- Next, uncheck the ‘
’ and ‘*Starting at*’ checkboxes, enter 46 and 100 in the respective text boxes beside them, then enter 10 in the text box below them to group*Ending at*10 and, then click*By*.*OK*

- Finally, you will get the desired
. You can do some changes to the**PivotChart**mentioned in the first method similarly.**Histogram**

## Conclusion

These are all the steps you can follow to **plot a histogram in Excel**. Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.

For more information like this, visit **Exceldemy.com**.