Frequency Polygon – Excel & Google Sheets

This tutorial will demonstrate how to create a Frequency Polygon in Excel & Google Sheets.

Create a Frequency Polygon in Excel

We’ll start with the frequency distribution table below:

Starting Data for Frequency Polygon Graph in Excel

 

Find the Midpoint

First, find the midpoint of the lower and upper limits with the formula:

=AVERAGE(B6,C6)

Find Midpoint Average of Two Points for Frequency Polygon Graph in Excel

 

Create the Graph

  1. Select the Frequency Column
  2. Select Insert
  3. Click on the Line Graph Icon
  4. Select the first Line Graph

Create Line Graph for Frequency Polygon in Excel

 

Update X Axis

  1. Click on the X Axis
  2. Click Select Data

Update Horizontal X Axis for Frequency Polygon Graph Excel

 

3. Select Edit

Edit Horizontal X Axis with Midpoint Values for Polygon Frequency Excel

 

4. Highlight Midpoint Data points

Update Axis Labels with Midpoint for Frequency Polygon Graph in Excel

5. Click OK and your graph will look like this:

Final Frequency Polygon Graph in Excel

 

Create Frequency Polygon in Google Sheets

  1. Click on Frequency Column
  2. Select Insert
  3. Click Chart

Create a Line Graph for Frequency Polygon in Google Sheets

 

4. Change Chart Type to Line Chart

5. Select X-Axis

6. Click on box that shows Select a Data Range

Update X Axis Values for Frequency Polygon Graph in Google Sheets

7. Select Midpoint Data for Data Range

Update Data Range with Midpoint Values for Frequency Polygon in Google Sheets

8. Click OK and your final graph will look like this:

Final Frequency Polygon Graph in Google Sheets