QI Macros SPC Software for Excel Lesson 6

QI Macros Lesson 6 - Automated Control Chart Dashboards
home · products · services · search · view cart · contact

NAVIGATION

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

To Create Control Chart Dashboards Using the QI Macros:

1. Click on the QI Macros pull down menu and select Control Chart Dashboard. Then open either the XmR Dashboard or the c, np, p, u chart Dashboard.

2. Each dashboard has an instruction sheet, a data input sheet and a sheet for each available control chart and a run chart.

XmR Dashboard Template

XmR control chart dashboard tabs

c, np, p, u Dashboard Template

c, np, p, u control chart dashboard tabs

3. Input or cut and paste your data into the Data Input Sheet.

4. Now click on the sheet for the desired chart. You will see a chart for the first data set.

control chart template excel

Click on the previous and next arrows to view charts for each data set.	Click on the Create Dashboard icon to create a dashboard with each chart.

Once you click on Create Dashboards, a macro will run for several seconds and a new Dashboard sheet with all of the charts will be created.

example of control chart dashboard

Like the other control chart templates in the QI Macros, you can run stability analysis on these charts by clicking on each chart and then selecting Analyze Stabilty on the QI Macros menu. The QI Macros will run stability analysis and turn any unstable points or conditions red.

To add new data to your charts, just go to the data input sheet and add your new data. The charts on the XmR or other control chart templates will automaticaly update. To update the charts on the dashboards, click on the Refresh Charts icon.

control chart dashboard refresh button

Note: About adding new charts after you create a dashboard.

Once you create a dashboard, the number of charts on the dashboard is set. You cannot add data into a new chart column on the data sheet and add it to the existing dashboard. You will need to open a new dashboard template and cut and paste your data input sheet into the new template and create a new dashboard. As discussed above, you can add data to existing charts you just can't add a new chart to an existing dashboard.

View Control Chart Dashboard Tutorial - 6 minutes

Thank for your interest in the QI Macros. View our articles and lessons archive.

View previous lesson

To sign up for this series tell your friends to send an email to qimacros@aweber.com

QI Macros - One License Per Computer - Download Now and Get Backup CD & User Guide (#230) in 1-3 days - $199 + S&H
QI Macros - One License Per Computer - Download Only - No Shipping or Customs Duties (#W230) $199

If you love the QI Macros...
Please ask a handful of friends to download the trial version. Here's what to say:
Need easy to learn, easy to use software for Lean Six Sigma and SPC that works right in Microsoft Excel? Test drive the QI Macros!
Find out more at www.qimacros.com/excel-spc-software.html.
Get a 30-day trial at www.qimacros.com/free-spc-software.html.

Going to a meeting of quality professionals?
We can send you as many QI Macros 30-day trial CDs as you need. Just send an email with the address and quantities needed to orders@qimacros.com.

FREE Lean Six Sigma Course & QI Macros 30-day Trial
Name:
E-mail
How did you hear about us? *
We hate spam as much as you do, so we never share your email with anyone for any reason.

Download
QI Macros
30-Day Trial Now!

QI Macros Lesson 6 - Automated Control Chart Dashboards

To Create Control Chart Dashboards Using the QI Macros: