How to Create a Run Chart

By Business & Finance Last updated Friday, May/24/2024

1). Enter column headers. In Excel, put "Date" in cell A1, the name of the variable you are tracking (such as weight/value) in cell B1 and "median" in cell C1.
2). Add dates. Add the dates that you recorded data on in column A. For example, you might have 10/1, 10/2, 10/3, 10/7, 10/8. Usually, though, you will have a longer series.
3). Add the values. Add the values you observed in column B. For example, you might have 150, 151, 152, 151, 150.
4). Find the median. At the bottom of column B, click "Formulas," then "More functions," then "Statistical" and "Median." Copy this number into column C next to each row that has data in column B. Then delete it from column B. In our example the median is 151, so add 151 to cells C2 through C6.
5). Add a chart. Click "Insert," then "Line with markers." This will be your run chart.

Breaking news and analysis from VeryPages. Politics, world news, photos, video, tech reviews, health, science and entertainment news.