QI Macros Control Chart Menu

Remember and Apply Chart Formats

A real time saver for those who want to customize chart formats in Excel.

Existing Charts Created with a Macro 

First "Remember Chart Format"

  1. After creating a chart, customize the fonts, colors and styles, etc., then click on the chart and the QI Macros chart menu and select, "Remember Format."

    Remember Custom Chart Format with QI Macros in Excel
  2. QI Macros will use Excel's custom chart template feature to "remember" the format.

Apply Custom Chart Format

  1. After creating a new chart, click on the chart and then click on the QI Macros chart menu and select Apply Format.

    Apply Custom Chart Format with QI Macros in Excel
  2. QI Macros will find the appropriate chart template and apply it to the chart. If a custom format does not exist, QI Macros will prompt you to create one.
  3. If there is more than one chart on a worksheet, you can click "Apply to All" which will apply formats to every chart on the worksheet (but not every chart on every sheet in a workbook).

Limitations

  • Control charts will all be formatted in the same way. You cannot have custom formats for different types of control charts (e.g., c, np, p, u, XmR).
  • Charts embedded on a worksheet (e.g., control chart templates) have to be remembered differently from charts on chart sheet. If you remember a chart on a "chart sheet" (e.g., p chart created with a macro), it cannot be applied to an embedded chart (e.g., p chart template)..
  • Skyline control chart formats in Excel 2007-2010-2013-2016 will be remembered in "wave" format, applied and converted back to Skyline style.
    This applies to p, u, XbarR, and XbarS charts.

    Caveat: Excel 2007-2010-2013-2016 have what I would call "memory" problems. They don't remember the chart format correctly. I have created workarounds to solve these problems in Excel, but there may be more. If you find one, send us the file and we'll try to figure out what is going on.
  • Because of problems with Excel 2007-2010-2013-2016 "memory", it is not possible to remember custom formats for ANOM and Box & Whisker charts.
  • Custom chart formats will not be applied automatically when created.

QI Macros Custom Chart Formats

You should see this menu:

These formats can also be applied manually using Chart Tools-Design-Change Chart Type-Templates:

  • QIControl Chart (emb)
  • QIHistogram (emb)
  • QIPareto (emb)
  • QICusum (emb)
  • QIHotelling (emb)
  • QICapability (emb)
  • QIDotPlot (emb)
  • Other chart formats will be remembered with "QI" and the the type of chart (e.g., a line chart will be "QILine"). More complex charts will be remembered with the numbers of each type of chart (e.g., QI4-52)

Excel Chart Numbers

Learn More...


Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

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

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