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

Chart Tools
Control Chart Tools
Chart Format Tools

Chart Tools for Use with Most QI Macros Charts

add to 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.

control chart tools menu

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


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?

affordable

Affordable

  • 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