Include Top

How Do I Create Run Charts in Excel Using SigmaXL?

  1. Click Sheet 1 Tab of Customer Data.xlsx. Click SigmaXL > Graphical Tools > Run Chart. Ensure that entire data table is selected. If not, check Use Entire Data Table. Click Next.

  2. Select Overall Satisfaction, click Numeric Data Variable (Y) >>. Select Show Mean. Uncheck Nonparametric Runs Test (to be discussed later in Part N of Analyze Phase).

  3. Run Chart Variables

  4. Click OK. A Run Chart of Overall Satisfaction with Mean center line is produced.

  5. Run Chart

  1. Select the Y axis, Right Click, Format Axis, to activate the Format Axis dialog. Change Minimum to 1, Maximum to 5, Horizontal axis crosses > Axis value to 1:

  2. Run Chart

  3. Click OK.

  4. Are there any obvious trends? Some possible cycling, but nothing clearly stands out. It may be interesting to look more closely at a specific data point. Any data point value can be identified by simply moving the cursor over it:

    Data Point Value

  5. A label can be added to a data point by one single-click on the data point, followed by a Right mouse click, and select Add Data Label. See also SigmaXL Chart Tools > Add Data Label in Control Phase Tools, Part B - X-Bar & Range Charts.

    Format Data Point

  6. Click OK. Resulting Run Chart with label attached to data point:

  7. Run Chart

  8. This label can be changed to a text comment. Single-click three times on the label and type in a comment as shown:

    Run Chart

Define, Measure, Analyze, Improve, Control

Lean Six Sigma Software Excel Add-in

Simulate, Optimize,

Lean Six Sigma Software Excel Add-in

Web Demos

Our CTO and Co-Founder, John Noguera, regularly hosts free Web Demos featuring SigmaXL and DiscoverSim
Click here to view some now!

Contact Us

Phone: 1.888.SigmaXL (744.6295)