Ogive Chart & Constructing an Ogive in Excel

For example, if you saved $300 in both January and April and $100 in each of February, March, May, and June, an ogive would look like that shown below. [1]





Constructing an Ogive in Excel

An ogive graph is a Line Chart in Excel.  An ogive can be constructed using cumulative frequency, cumulative relative frequency, or cumulative percentage.  To construct a cumulative frequency ogive for the frequency distribution, first select the range of cells containing the cumulative frequencies.  Click the ChartWizard button on the toolbar[2].

Step 1 (Type):  Select chart type (click Line) and then select chart sub-type (click Line).  Click Next>.
Step 2 (Source Data): The cell range that you highlighted should be showing in the Data range box and the arrangement of the data series is in Columns.  Click the Series tab at the top of the window.  Click in the box labeled Category (X) axis labels.  Click the red marker (this will send you back to your worksheet) and select Class Intervals cells.  Click the red marker to return to the ChartWizard.  Click Next>.
Step 3 (Options): 
1. Select the Titles tab.  Enter the chart title, X-axis label, and Y-axis label.
2. Select the Legend tab.  Click the check in the Show legend box to remove it.
3. Click Next>.
Step 4 (Location): If you want the graph to appear in a separate chart sheet, click As new sheet.  If you want the graph to appear in the worksheet with your frequency distribution, click As an object in and select the worksheet containing your frequency distribution.  Click Finish.


[1] http://www.rock-hill.k12.sc.us/teachers/phoenix/dralyea/Lessons_Larson/relative_cummulative_histogram.htm

[2] http://www.cob.sjsu.edu/anaya_j/Graphs.htm