How to make a survivorship curve chart on excel

Written by vera leigh
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to make a survivorship curve chart on excel
Make a curve chart of your data with Microsoft Excel. (Stockbyte/Stockbyte/Getty Images)

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.

Skill level:


  1. 1

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

  2. 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.

  3. 3

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

  4. 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.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.