# How to Make an Ogive Graph in Excel (with Easy Steps)

### Step 1 – Creating Two Helper Columns

We have a dataset of a company’s Remuneration Range and Frequency.

• Construct two columns named “Class Limits” and “Cumulative Frequency” on the right side of the previous table.

Read More: How to Do Cross Tabulation in Excel

### Step 2 – Determining Limits and Cumulative Frequencies

• Fill the Class Limits columns with values starting from \$0 and ending with \$100,000.

• Apply the following formula in cell F6:
`=SUM(\$C\$5:C5)`

• Hit Enter and drag the Fill Handle down to fill the cells in the column.

### Step 3 – Plotting the Ogive Graph

• Choose the data from the second table and click Scatter Chart from the Insert option.

• We will get the ogive graph.

### Step 4 – Modifying Axes and Data Labels

• Select the graph.
• Right-click and select Format Axis.

• Change the value of the maximum bound to “0” and the unit Major value to “10000.0”.

• Change the vertical axis value to “0” in the “Maximum” box.

• Select any data point from the graph and right-click on it, then choose Add Data Labels.

• From the right pane, change the format of the Data Labels by switching to Above.

• Here’s the result.

## Things to Remember

• An ogive graph is made using a scatter chart but you can create it with a line chart if you want.

## Related Articles

Get FREE Advanced Excel Exercises with Solutions!
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF