Filter/Unfilter Data Set on a Control Chart

Automatically filter or unfilter your chart within Excel

Included in the 10.2020 version of QI Macros

If your chart is unfiltered and includes blank rows of data, use the "Filter/Unfilter Chart" function to automatically filter your data set.

To filter or unfilter your chart:

  1. Select your chart and from the "QIMacros Chart" portion, click "Filter/Unfilter Chart":
  2. qi-macros-chart-menu-filter-unfilter

  3. This functionality will automatically filter your data, should you have blank rows appearing within in your data set:
  4. unfiltered-chart

  5. Once the "Filter/Unfilter Chart" button is selected, your chart will be filtered:
  6. xmr-chart-filtered

  7. If you are using a Control Chart Template, and would like to add data to a filtered data set, select your chart and choose "Filter/Unfilter Chart" - this will re-expand your data rows. You can then add data to your Control Chart Template again, without having to use the Unhide function within Excel.

Note: It is not possible to use this functionality with the Rolling or Scrolling Control Chart Templates.

Learn More...

Why Choose QI Macros Over Other Control Chart Software?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free



  • Only $349 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support