Create Histogram in Excel step by step

In this tutorial we will see how to create Histogram in Excel. Histogram is the frequency distribution of data
Data:
The data we use for creation of Histogram in Excel is shown below. The data represents the score of students in the science subject. We have also created the bins based on which the histogram is created.

Histogram in Excel 1

 

Step 1: On the top right corner of the data tab click data analysis.

Histogram in Excel 2

Note: if you can’t able to find the Data Analysis button? Click here to load the Analysis ToolPak add-in.

 

Step 2: Select Histogram and click ok.

Histogram in Excel 3

 

Step 3: Click in the Input Range box and select the Range A2:A20 and Bin Range C2:C6.  And select the output range as E2 and check the chart output box, as shown below and click ok

Histogram in Excel 4

 

So, the output will be

Histogram in Excel 5

Step 4: Remove the space between the bars Right click a bar, click Format Data Series and change the Gap Width to 0%.

 

Step 5: Add the border – Right click a bar, click Format Data Series, click the Fill & Line icon, click Border and select a color.

So the final output chart will be

Histogram in Excel 6

previous small Histogram in excel                                                                                                                 next small Histogram in excel