QI Macros Automate the Most Common Control Chart Tasks

Access These Short Cuts Using QI Macros Chart Menu

Once you create a control chart or other chart using QI Macros, you can easily update it using the QI Macros Chart Tools menu. To access the menu, you must be on a chart or on a chart embedded in a worksheet.

QI Macros Chart Menu is divided into three sections

1. Chart Tools, 2. Control Chart Tools and 3. Chart Format Tools


1. Chart Tools for Use with Most QI Macros Charts

add data add target line to chart

Easily add data, text notations or goal and target lines to charts. For more information see these links.

2. Control Chart Tools

These options give you maximum flexibility to customize control charts with just a few clicks of a mouse.

update control charts

Change the data points used to calculate control limits:

Re-run stability analysis after changing data or control limit calculations:

Change How Sigma and Control Limit Lines are Displayed

3. Chart Format Tools

remember chart format

A huge time saver for those who like to customize various chart elements!

  1. Customize one chart with the fonts, styles, colors, etc. you want.
  2. Click Remember Format
  3. Create another chart and click Apply Format to make the same changes on the second chart.
  4. Click Apply To All if your worksheet (not workbook) has more than one chart on it.

4. Move Chart Tools (added March 2016)

Move Embedded Excel Chart Tools - QI Macros

A time saver for those who need to move embedded charts!

  1. Use Move Charts to export all embedded charts on a worksheet to their own worksheets
  2. Use Move All Charts to export all embedded charts in a workbook to their own chart sheet.

Learn More About QI Macros Control Charts

Why Choose QI Macros Over Other Control Chart Software?



  • Only $279 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