In turn, enter the Input Range, Bin Range, and Output Range as shown below.From this list, choose the Histogram option.In the next step, choose the Analysis ToolPak option and click OK.Now, a dialog box opens where you have to click the Add-ins > Go button.Initially, navigate to File > Excel Options.Now, allow me to demonstrate the process bit by bit. If you’re hoping for a shortcut, then I have some good news for you! Here, we’re going to utilize the Analysis ToolPak to create the Frequency Distribution Chart. Lastly, insert Axis Titles from the Chart Elements option.Įventually, the results should look like the below image.ġ.2 Using Data Analysis ToolPak to Create Frequency Distribution Chart.Following this, go to Border > Solid Line and choose a Color.Then, double-click on any of the bars to open the Format Data Series window.Next, go to Insert > Insert Column or Bar Chart > Clustered Column.Secondly, select the Age Bracket 2 and the Number of Member columns.📌 Step 02: Insert the Chart and Add Formatting In the above formula, the C5:C14 and the E7:E13 cells indicate the Age and the Age Bracket 1 columns respectively. Then, we enter the expression given below.Now, in this dataset, the Age value starts at 25, so we set the starting value of the bin to 20. At the very beginning, add a column for the bins, in this case, Age Bracket 1.Here, the dataset shows the names of the club Members and their Ages respectively.ġ.1 Applying FREQUENCY Function to Make Frequency Distribution Chartįor our first method, we’ll utilize the FREQUENCY function to create a frequency Distribution Chart or Histogram. Let’s say we have the information for Oakmont Ridge Golf Club shown in the B4:C14 cells below. Creating a Frequency Distribution Chart in ExcelĪ Frequency Distribution or Histogram represents the data in ranges or bins, making it easy to interpret the data. So, without further delay, let’s dive into the methods!ġ.

Related Articles 2 Methods to Create a Distribution Chart in Excelįortunately, you can easily represent this dataset in a Distribution Chart using Microsoft Excel.

How to plot histogram in excel