An **ogive **is a graph that shows how many data values lie above or below a certain value in a dataset. This tutorial explains how to create an ogive in Excel.

**Example: How to Create an Ogive in Excel**

Perform the following steps to create an ogive for a dataset in Excel.

**Step 1: Enter the data.**

Enter the data values in a single column:

**Step 2: Define the class limits.**

Next, define the class limits you’d like to use for the ogive. I’ll choose class widths of 10:

**Step 3: Find class frequencies.**

Next, we’ll use the following formula to calculate the frequencies for the first class:

Copy this formula to the rest of the classes:

**Step 4: Find cumulative frequencies.**

Next, we’ll use the following formulas to calculate the cumulative frequency for each class:

**Step 5: Create the ogive graph.**

To create the ogive graph, hold down CTRL and highlight columns D and F.

Along the top ribbon in Excel, go to the **Insert **tab, then the **Charts **group. Click **Scatter Chart**, then click **Scatter with Straight Lines and Markers**.

This will automatically produce the following ogive graph:

Feel free to modify the axes and the title to make the graph more aesthetically pleasing:

Do you happen to know how to do this in Numbers on a Macbook? I get as far as making the graph but when you say to choose “Scatter with Lines,” this isn’t an option in Numbers.

Is there a way to put multiple lines for different datasets on one ogive graph?

Simple.thanks Sir