## Six Sigma Basics: Using Excel to Make a Run Chart

written by: Misty Faucheux • edited by: Marlene Gundlach • updated: 6/30/2013

You know that you can do so many things in Excel. Well, add creating a Six Sigma run chart to your list. It's simple to do and saves you a lot of time. Learn how to create one today!

• slide 1 of 4

### Overview of a Run Chart

A run chart is a form of control chart. It is considered the simplest form of a control chart because it only shows the elementary measurements of data tracked over a period of time. A control chart tracks variation over time. A process is considered "out of control" if the process has changed over time.

With a run chart, you can use a center line to create your mean or median. You won't, however, have any control limits. You can use the run chart to group samples together and run statistical tests. If you have simple patterns that you are trying to compare, you can easily see if your process is out of control by simply looking at the chart.

A run chart allows you to plot your data over time. Your X axis shows your time measurements, and your Y axis shows what is being measures.

• slide 2 of 4

Now, you can create your run charts using Excel and their QI Macros SPC Software (\$139 online). To create your charts, you can  follow these steps.

1. Go to File New Worksheet.

2. Right click on Sheet 1 at the bottom, and click rename.

4. Choose the data that you want to compare.

5. Select the type of chart that you wish to use from the QI Macros pull-down menu.

• slide 3 of 4

### Finding the Median

Since one of the major components of the run chart is the median, you want to be able to find this in your Excel document. Follow these steps to figure out your median in Excel.

1. Go to Insert, and click on Function (fx).

2. Click All in the left-hand side.

3. In the right-hand column, scroll down until your find Median.

5. Click OK.

The median for the figures that you inputted will show up in the cell.

For information on ten free Six Sigma templates, read 10 Free Six Sigma Templates You Can Download by Michele McDonough.

1. Input the dates and data from your research into the Excel cells.

2. Input the median from your calculations, and add this information to each date.

3. Select the data that you want to chart on your run chart.

4. Click the Chart Wizard icon.

5. Select Line Chart from the Chart Type menu.

6. Fill in the required information on the menu.

7. Once all the information has been entered, Excel will create your chart for you.

To learn how to create a Gantt Chart in Excel, read Using Excel to Create a Gantt Chart by Michele McDonough.

• slide 4 of 4

### Changing the Rules

If you want to alter how your line looks, you can click on the median or data lines.

If you need to change the rules for your chart, this can easily be done by following the below procedures. You must always remember to select line chart since Excel's default chart is bar.

2. Click Control Charts and then Control Chart Rules.

3. Pick which rules apply to what you are doing. It may take a few minutes to update the rules file.