Then, you have to assign a cell as the Output Range where the output chart and frequency table will be created.

In this part, I have selected cells C17:G17 as the Bin Range.

Then, select the Bin Range of the Histogram.

Here, I have selected C5:C15 as the Input Range which contains the marks of English.

Here, select the data range for which you want to create a Histogram in the box named Input Range.

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

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

After that, you will be able to access the Data Analysis tool.

Next, check the Analysis ToolPak checkbox and click OK.

Then go to the Add-ins tab and click on Go beside Manage: Excel Add-ins.

At first, press ALT + F + T or select File > Options.

In this section, I will show you the quick and easy steps to make a Histogram in Excel using Data Analysis ToolPak. Applying Data Analysis Toolpak for Plotting Histogramĭata Analysis Toolpak is one of the best features of Excel when we need to do advanced statistical analysis. Read More: How to Make a Histogram in Excel Using Data AnalysisĢ.

Lastly, you will get your desired Histogram.

From the Chart Elements select the mentioned items.

Also, you may change the Overflow bin and Underflow bin.

Then, from the Axis Options, change the Bin width according to your choice.

Again, double-click on the bins values, and a new window named Format Axis will appear beside the worksheet.

Increase the Gap Width according to your preference from the Series Option.

So, a new window named Format Data Series will appear beside the worksheet.

After that, a Histogram will appear, and double-click on the rectangle.

Thirdly, from the Charts group section, you have to select the Insert Statistic Chart and then select Histogram.

Secondly, you have to go to the Insert tab.

However, follow the steps below to complete the operation. Because the H istogramchart will take into account the entire data range and base its result on that. Actually, Excel comes with this feature built in. If you are using Excel 2016 or a later version, you can insert a statistical chart to build a histogram in Excel. Using Statistic Chart to Plot Histogram in Excel For the purpose of demonstration, I have used the following sample dataset.ġ. However, it includes Statistic Chart, Data Analysis Toolpak, FREQUENCY function, COUNTIF function and Pivot Chart. In this part, I will show you five simple methods to plot Histogram in Excel.

Fortunately, there are numerous approaches to making a histogram in Excel.

How to plot a histogram in excel