Find any point on a chart in your data set

QI Macros "select data for point" feature

Once you draw a control chart using QI Macros, you may want to research a data point that looks odd. When you have lots of data points on a chart, its hard to identify which point you want to investigate using the x axis labels. That is why we created the "Select Data for Point" feature.

To locate your data using the "Select Data for Point" function, follow the instructions below:

  1. Once you have drawn a Control Chart, click on the point you are interested in:
  2. select data for point

  3. Next click on Select Data for Point which is located under the "Process Changes" drop-down menu:
  4. qi-macros-process-change-drop-down-menu

  5. Once you have done so, your cursor will move to the x-axis label associated with that data point:
  6. select data point example

    In this example, the cursor ends up in cell A17 so we know that data for July 29, 2020 is what we are interested in.

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