Add Target or Goal Lines to Control Charts

Use Goal or Spec Limit Lines to Compare to Targets

Control chart limits are calculated from your data. However, many customers also want to show a target or spec limit line for comparison.

add target, goal, or spec limit to control chart

QI Macros Control Charts Provide Several Ways to Add a Target Line

Option 1: Easy to Use Add Target Line Feature on QI Macros Chart Menu

  1. Click on a chart, then click on QI Macros Chart Menu. The Add Target Line to Chart tool is on the far left:

     chart tools menu
  2. Click on Add Target to Chart and it will prompt you to name the line and designate its value:

    label your target line input your target value
  3. You can add as many lines to your chart as you need.

Option 2 - Use Excel's drawing tools to simply draw a target line on your existing control chart.

  1. To view Excel's drawing tool bar select View/Tool bars and check the box next to "Drawing."
  2. Next simply draw a line on your chart.
  3. You can use the text box feature on the drawing tool bar to add a label to the line.
  4. Note: If you add data to the chart you may need to re-sync up the line.

NOTE: It is not possible to perform an Add Target Line to a Run Chart Dashboard.

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