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.
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.
- Start with determining the cumulative frequency and apply the following formula in cell (F6)-
=SUM($C$5:C5)
- 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
- How to Create Venn Diagram from Pivot Table in Excel (2 Ways)
- Make Games in Excel (with Easy Steps)
- How to Create a Word Cloud in Excel (2 Easy Ways)
- Change Comma to Dot in Excel (4 Handy Ways)
- How to Show Full Cell Contents on Hover in Excel (5 Quick Ways)
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.
- 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”.
- From the right pane, change the value of the maximum bound to “0” and the unit Major value to “10000.0”.
- 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”.
- 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.
- In conclusion, we have successfully made an ogive graph in Excel displaying cumulative frequencies.
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
- How to Make a Venn Diagram in Excel (3 Easy Ways)
- Make Sankey Diagram in Excel (with Detailed Steps)
- How to Make Fishbone Diagram in Excel (with Easy Steps)
- Graph Uncertainty in Excel (2 Easy Ways)
- How to Edit Document Properties in Excel (with Detailed Steps)
- Use Money in Excel (with Easy Steps)
- How to Show Ruler in Excel (with Simple Steps)