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

Chart Tools
Control Chart Tools
Chart Format Tools


Chart Tools for Use with Most QI Macros Charts

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

Control Chart Tools

Options to give you maximum flexibility to customize control charts with just a few clicks of a mouse:


Change the data points used to calculate control limits:

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

Change Which Control Limit Lines are Displayed and How They are Formatted

Change UCL/LCL

Miscellaneous Chart Menu Option

Chart Format Tools

chart format tools menu

Remember and Apply Chart Formats: 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.

Change Titles: Simplifies updating chart titles by providing prompt boxes for X axis, Y axis and chart title.

Move Charts

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

Copy charts to PowerPoint and Word

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