📌 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.
