Pin Me

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.

    For more information on run charts, read Jean Scheid's Six Sigma Glossary.

  • slide 2 of 4

    Creating Your Chart

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

    1. Go to File New Worksheet.

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

    3. Rename your worksheet.

    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.

    To read how Six Sigma can improve your organization, read How to Implement Six Sigma.

  • slide 3 of 4

    Finding the Median

    www.qimacros.com 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.

    4. Input your numbers.

    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.

    To create your run chart, you should follow these steps.

    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.www.qimacros.com 

    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.

    1. Go to your QI Macros menu.

    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.

    4. Run your selected chart.

    For more information on six sigma, read Six Sigma is Essential in Project Management Planning by JScheid.