Add Target or Goal Lines to Control Charts

Use Goal or Spec Limit Lines to Compare to Targets

Control chart sigma lines and upper control and lower control limits are calculated from your data. However, many customers also want to show a show a target or spec limit line on their control chart.

control chart with target goal or spec limit

QI Macros allow you to add a target line using in several ways:

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

To use this feature, click on a chart, then click on QI Macros Chart Menu. The Add Target Line to Chart tool is on the far left. It will prompt you to name the line and designate its value. Add more than one line if needed. This will work on most charts, but not on pie or radar charts:

add target line to control chart 

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.

Additional Step for Certain Charts

In the p, u, XbarR, XbarS charts, Excel may use the "no line" format of other lines on the chart as a basis for formatting the target line. To show the target line, click on the chart, Then Chart Tools-Layout-Chart Area pull down menu and select Target:

Select hidden Excel chart series

Then Click on Format Selection, then Line Color and select solid line and a color:

Format hidden Excel chart series

If you still can't see the target line, it may be because your X axis is a date or number. To reveal the line:

  1. Right click on the chart and choose Select Data:

  2. Select Target and Choose Edit:
  3. Clear the Series X values and Click OK:

Learn More...


Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $249 USD - less with quantity discounts
  • No annual 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

  • 100,000 users in 80 countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus free