How to Plot Relative Risk in Microsoft Excel

Written by carter mcbride
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Plot Relative Risk in Microsoft Excel
Excel features a data plotting feature to help you make graphs. (B2M Productions/Polka Dot/Getty Images)

To plot relative risk, you need two sets of figures from your relative risk data set. This data set includes how the relative risk changes with the covariant, such as length. Using this data, you can plot the relative risk on the y-axis and the covariance on the x-axis. You can use Microsoft Excel to plot this chart after you enter in your data for the relative risk. Excel then creates a graph for you.

Skill level:


  1. 1

    Type your covariate data in column A. You can use row 1 as a title row.

  2. 2

    Type your corresponding relative risk data in column B. You can use row 1 as a title row.

  3. 3

    Highlight the cells.

  4. 4

    Click "Insert" then "Line."

  5. 5

    Click anywhere on the chart to activate your chart with the relative risk data plotted.

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.