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

Get FREE Advanced Excel Exercises with Solutions!

An Ogive graph is a graph that is used to visualize cumulative frequencies. The main motive of this graph is to display the total number of data points that are greater than or equal to a particular given value. Today in this article, I am sharing how to make an ogive graph in Excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


4 Quick Steps to Make an Ogive Graph in Excel

In the following, I have described 4 simple and quick steps to make an ogive graph in Excel.


Step 1: Creation of Two Helper Columns

Suppose we have a dataset of a Company’s Remuneration Range and Frequency. In this step, we will create two helper columns to create the graph in a proper way.

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

Creation of Two Helper Columns to make an ogive graph

Read More: Create Butterfly Chart in Excel (2 Easy Methods)


Step 2: Determination of Limits and Cumulative Frequencies

Next, we will fill the Class Limits columns with cumulative values starting from $0 and ending with $100000.

Determination of Limits and Cumulative Frequencies to make an ogive graph in Excel

  • Start with determining the cumulative frequency and apply the following formula in cell (F6)-
=SUM($C$5:C5)

Determination of Limits and Cumulative Frequencies to make an ogive graph in Excel

  • Simply, hit ENTER and drag the “Fill Handle” down to fill the cells in the column.

Read More: Create an Organizational Chart in Excel (2 Suitable Ways)


Similar Readings


Step 3: Plotting of Ogive Graph

After preparing the data in the necessary form, we have our cumulative dataset ready for plotting an ogive graph.

  • Just choose the data from the table and click the “Scatter Chart” from the “Insert” option.

Plotting of Ogive Graph to Create Ogive Graph in Excel

  • In summary, we will get the ogive graph in our hands.

Read More: Get Summary Statistics in Excel (7 Easy Methods)


Step 4: Modifying Axis and Data Labels

In this final step, we will need to modify the graph using the “Format Axis” and “Data Labels” features.

  • Simply, select the graph click the right button of the mouse, and choose “Format Axis”.

Modifying Axis and Data Labels to make an Ogive Graph in Excel

  • From the right pane, change the value of the maximum bound to “0” and the unit Major value to “10000.0”.

Modifying Axis and Data Labels to make an Ogive Graph in Excel

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

  • This time we will add “Data Labels” to our graph. To do so, choose any data point from the graph and right-click the mouse button to get multiple options. From the appeared options choose “Add Data Labels”.

Modifying Axis and Data Labels to make an Ogive Graph in Excel

  • Now, from the right pane, let’s change the format of the “Data Labels” by switching to “Above”. So, the values will be displayed above the line.

Modifying Axis and Data Labels to make an Ogive Graph in Excel

  • In conclusion, we have successfully made an ogive graph in Excel displaying cumulative frequencies.

How to Make an Ogive Graph in Excel

Read More: How to Set Intervals on Excel Charts (2 Suitable Examples)


Things to Remember

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

Conclusion

In this article, I have tried to cover all the steps to make an ogive graph in Excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo