How to Make a Survivorship Curve Chart on Excel

By Vera Leigh

If you have Microsoft Office Excel on your computer, then you can use it to create a database of numbers that can be transformed into a chart reflecting survivor statistics from a disaster, disease or other event or condition. Microsoft Excel offers a variety of curve charts that are useful for translating numbers into an educational graphical representation of your data.

Step 1

Open Microsoft Excel. A new spreadsheet will appear on your screen.

Step 2

Enter your survivorship data in cells A1 and down. Think of each cell as representative of a year and each number you enter into that cell representative of the people who survived. You can enter the data directly into the cell by clicking on it.

Step 3

Press "Ctrl" and the "A" button at the same time.

Step 4

Click the "Insert" tab, followed by the "Line" icon. Select a style of curved line graph. Recommended is the 3-D line graph. Once you select the style, Excel will convert your data into the curved line graph. The graph will appear on your screen.

References & Resources