Creating a frequency distribution in Microsoft Excel is a simple process that can be completed in a few minutes if the appropriate data sets are available. To create a frequency distribution chart, you need access to Excel and to the rows and columns of data you will be charting.
- Open Excel and insert a pivot table
Double click on Microsoft Excel, and open the file that contains the data you will be displaying. Click on "Insert," and then choose "PivotTable." Press "OK" when prompted by the dialogue box. Inside the pivot table field list, select the data column or row you will be using as both a "value" and a "row label."
- Group together the correct information
Right click on any cell inside the data you are using. From the menu that appears, select "Group." Enter the appropriate start and end points for the data set. You can double check this by looking at the numbers next to the cells. If the data you are using is the only set present in its column, you may enter 0 and 1,000 for the start and end points. This groups together the entire set.
- Insert an appropriate chart based on the data
Click on any cell inside of the pivot table. Choose "Insert" from the top menu, and then press "Charts." Many of the different charts available create a frequency distribution. Select the chart type of your choosing. One of the easiest charts to use and read is the column frequency distribution chart.