Quality America Inc.

Contact Info

Email Sales

Log In

Site Search

Menu

Show navigation Hide navigation
  • SPC Software
    • SPC-PC IV Explorer
    • QA-Calibrate
    • SPC IV Excel
    • Green Belt XL
    • My Software
  • Training & Certification
    • Certification Courses
    • Short Courses & Study Guides
    • Instructor Materials
    • Process Excellence Books
    • Knowledge Center
    • My Courses
  • Company
    • About Us
    • Catalog
    • Satisfaction Guarantee
    • Development Process
    • Privacy Policy
    • Contact Us

You are here:

  1. Home
  2. SPC Software
  3. SPC IV Excel
  4. Slideshow
  5. Removing Subgroups from the SPC Analysis

Product Nav

  • Tutorial
  • Step One - Select a Chart
  • Step Two - Organize Your Data
  • Step Three - Options
  • Step Four - Placement
  • Your Finished SPC Chart
  • Displaying Statistics and Other Format Options
  • Filtering your SPC Excel Analysis
  • Removing Subgroups from the SPC Analysis
  • Quickly Display Process Shifts
  • Basing Control Limit on Fixed Values or Subsets of Data
  • Adding Notes to Your SPC Chart
  • Distributing Your SPC Analysis
  • Try SPC IV Excel Yourself

Removing Subgroups from the SPC Analysis

In addition to the automated filtering, you can also remove a selected subgroup from the analysis using the Subgroup Status option in the right mouse menu (available when a subgroup is selected in the chart).

Dropping subgroups from SPC chart in Excel

By default, subgroups shown on the chart use the first option: they are included (i.e. shown) on the chart, and included in the calculations of the various statistics. In this example, we'll select the third option to remove the selected subgroup from the calculations. In this case, the subgroup will be shown on the chart, but will be drawn with a white dot (rather than a black dot), as shown in the chart below, to indicate it has been removed from the statistics. The second option in the Subgroup Status dialog box would remove the subgroup from the chart and the calculations, the same result as if it were not included in the data range.

You can use the Show Inactive Subgroups option in the chart;s right mouse menu to view and/or add back the subgroups previously removed from the chart and/or calculations.  

SPC chart in Excel after removing subgroups
« Previous
Up
Next »

Since 1982: The art & science to improve your bottom line

Quality America offers Statistical Process Control software, as well as training materials for Lean Six Sigma, Quality Management and SPC. We embrace a customer-driven approach, and lead in many software innovations, continually seeking ways to provide our customers with the best and most affordable solutions. Leaders in their field, Quality America has provided software and training products and services to tens of thousands of companies worldwide.

More//

Menu

  • SPC Software
    • SPC-PC IV Explorer
    • QA-Calibrate
    • SPC IV Excel
    • Green Belt XL
  • Training & Certification
    • Certification Courses
    • Instructor Materials
    • Short Courses & Study Guides
    • Process Excellence Books
    • Knowledge Center
    • My courses
  • Company
    • About Us
    • Satisfaction Guarantee
    • Development Process
    • Privacy Policy
    • Terms & Conditions
    • Contacts


sales@qualityamerica.com
Linked-In page

Copyright © 2025 Quality America Inc.
Quality America Inc.