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.
Step 1: On the top right corner of the data tab click data analysis.
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.
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
So, the output will be
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