Create Control Chart Dashboards in Minutes

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

Copyright © 2011

Do you spend too much time:

• Updating existing charts every month with new data?
• Organizing multiple control charts onto a singe page?
• Creating control chart dashboards for management?

The QI Macros control chart dashboards save you time by automating these tasks.

Here's How to Create a Control Chart Dashboard using the QI Macros:

View Control Chart Dashboard Tutorial (6 minutes) or follow these steps:

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.

Excel 97 to Excel 2003 menu	Excel 2007-2010 Menu

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

c, np, p, u Dashboard Template

XBarR Dashboard Template

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

Note about chart titles: Since we use thesechart titles to name sheets when the dashboard is created, make these names unique and limit them to 31 characters.

XmR Dashboard Data Sheet

Rows 1 and 2 of the XmR dashboard data sheet contain input cells for Upper Spec Limits and Lower Spec Limits. Input your spec limits here to be used in the histogram calculations. Note: LSL and USL defaults are estimated as the average +/- 3*stdev (this differs from the XmR Four Pack template which uses Sigma Estimator.)

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

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 charts will be created.

Like the other control chart templates in the QI Macros, 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.

To update the charts and re-run stabilty analysis, click on the Refresh with Stability icon.

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 always add data to existing charts you just can't add a new chart to an existing dashboard.

Watch Control Chart Dashboard Tutorial (6 minutes)

The QI Macros SPC Software for Excel has Five Parts and Numerous Wizards to Assist With Your Data Analysis:

1. Over 30 charts including histograms, pareto charts, scatter plots, box whisker plots and all variable and attribute control charts. Just select your data and then click on the QI Macros menu and select the chart you want to run. If you are not sure, select the Chart Wizard to run various charts on your data or the Control Chart Wizard to select the right control chart.
2. Over 90 Fill-in-the-blank templates and tools including fishbones, FMEA, DOE, Gage R&R, PPAP forms and more.
3. Statistical tools including Anova, f-test, t-test, regression, data normality test, sample size calculator and more. Select your data and click on the Statistics Wizard to run the most common statistical tests for your data.
4. Data Transformation Tools to help organize and analyze your data including stack and restack. Includes WordCount and PivotTable Wizards to help you summarize and organize your data.
5. Automated Control Chart Dashboards - just drop your data into these pre-formatted templates.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

It's easy to create measurement dashboards with the QI Macros

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!