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 make a histogram in excel mac