How to Create Quality Control Charts in Excel

Written by katrina matterhorn
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create Quality Control Charts in Excel
Create a representation of your data with an Excel quality control chart. (business graph in action image by Andrea Massimiani from

Quality control charts are a statistical representation of data to determine whether your information is in a situation of statistical control. It can be utilised to help predict the future performance of your data source. In addition, it can help you determine what factors need to be implemented in the case that your information is in an "out-of-control" statistical state. Furthermore, it can help you notice aberrations within your data so that you can modify them. Creating a quality control chart in Excel requires a few steps to configure.

Skill level:


  1. 1

    Distribute your data to revolve around a mean (average). Ensure your measurements are independent of each other. Create a subgroup for each data point and measurement number.

  2. 2

    Add all your measurements in the subgroup and divide by your number of measurements. Calculate the mean of all the means; this will determine your over all mean. Determine the standard deviation of your data points by using this command: "Standard deviation: =STDEV(data points)."

  3. 3

    Tally the upper and lower control limits (UCL, LCL). Enter this formula: "UCL = CL + 3S", "LCL = CL -- 3S." This conveys 3 standard deviations above and below your mean. This will process your 1, 2 and 3 sigma lines. Draw a line at each deviation you've calculated. Diagram the subgroup means "x-axis" counter to the "y-axis." Confirm that your points do not fall off any of your sigma lines. This can help you determine whether you data is "in-control" or "out-of-control."

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.