Find Any Point in Your Data Set

Click on your point to find where it is located in your Excel spreadsheet

QI Macros Provides Two Ways to Locate Your Data

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

  1. Create your Control Chart and click on your data point:
  2. select data for point

  3. Next, click on QIMacros Chart menu, select the "Process Changes" drop-down and choose, "Select Data for Point":
  4. select data for point menu process changes

  5. Or click on QIMacros Chart menu, select "Ghost, Delete or Show Point" drop-down and choose, "Select Data for Point":
  6. select data for point menu ghost delete or show point

  7. Once you have done so, the cell that contains the x-axis label will be selected:
  8. select for data output


Learn More...


Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $299 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

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