How to Make a Survivorship Curve Chart on Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Make a curve chart of your data with Microsoft Excel.

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.

Video of the Day

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.




Report an Issue

screenshot of the current page

Screenshot loading...