DISCOVER
×

How to make a survivorship curve chart on excel

Updated February 21, 2017

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.

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

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.

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

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.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Vera Leigh has worked as a professional freelance writer since 2008. Her work has appeared in "Learn Overseas" and "Grad Source" magazines. In addition, she received an honorable mention in "Newsweek's" My Turn contest. She has written features for nonprofits focused on literacy, education, genomics and health. In her spare time, Leigh puts her English major to use by tutoring in grammar and composition.