How to Make an Ogive in Excel

1. Open a new Excel spreadsheet. Type 'Data' into cell A1, then type 'Bins' into cell B1. Enter the data set that you want to use to create the Ogive chart into column A, starting with cell A2.
2. Enter the bins for your histogram into column B, starting with cell B2. The bins are the numbers that represent the top value in the data ranges for your histogram. For example, if you want to determine the frequency of ranges from '0 to 5,' '6 to 10' and '11 to 15,' your bins would be '5,' '10' and '15.' The bins will appear on your Ogive chart as values plotted on the horizontal axis.
3. Click 'File' and select 'Options' from the list the appears. Click 'Add-Ins' once the Options window appears, then click 'Go.' Place a check next to 'Analysis ToolPak,' then click 'OK.'
4. Select the 'Data' tab at the top of the screen, then click the 'Data Analysis' button on the right end of the Ribbon. Click 'Histogram' from the list in the window that appears, then click 'OK.'
5. Place your cursor in the 'Input Range' field in the Histogram window. Click cell A1 and hold down the mouse button. Drag the cursor down to the last cell in the first column that has data, then release the button. Place your cursor in the 'Bin Range' field, and select all filled cells in that column. Place a check in the box next to 'Labels.'
6. Place the cursor in the text field next to 'New Worksheet Ply' and enter a name for your worksheet. Place checks next to 'Cumulative Percentage' and 'Chart Output,' then click 'OK.' Your histogram and chart will appear on the screen.
7. Click the blue bars in the middle of the chart, then press 'Delete.' This will remove the frequency data and leave you with a line graph of your cumulative frequency.