Control Chart Dashboards in Excel

QI Macros Dashboards Can be Created and Updated in Seconds

Do you spend too much time?

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

Input Data Once and Update Charts With the Click of a Button

dashboard input sheet

arrow

example of control chart dashboard in Excel

Every two weeks I have to update 600 control charts for more than 30 hospitals in our system. I used to spend three days updating these charts. Once we created the charts using QI Macros Control Chart Dashboards, and utilized automation including stability analysis, we reduced the time it takes to update the charts to just three hours. The QI Macros Control Chart Dashboards save me valuable time that I can use for other important projects. Thanks for making this process quicker and easier. 

- Mary Ayuso
Adventist Health System


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

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

1. Click on the QI Macros menu and open one of the four available dashboards.

qi-macros-control-chart-templates-menu

Each dashboard contains several tabs:

c, np, p, u Dashboard Template
c chart | np chart | p chart | u chart | run chart

Levey Jennings Dashboard Template
Levey Jennings | Levey Jennings Percent | Levey Jennings Fixed Standard Deviation | Levey Jennings Target

XmR Dashboard Template
XmR AverageR | XmR Rolling | XmR MedianR | Run Chart

XBarR Dashboard Template
XbarR Chart | XbarR Skyline | Precontrol Xbar

xmr dashboard tabs

2. Click on the data input sheet and input or cut and paste data into the sheet.

dashboard input

 

Tip - Chart Titles: Chart titles are used to name worksheet tabs when the dashboard is created. Make these names unique and limit them to 31 characters.

 

Tip - Number of Charts: Input data for all of the desired charts before you create the dashboard.

 

3. Input spec limits or use the defaults - XmR and XbarR Dashboard only.

Rows 1 and 2 of the XmR and XbarR dashboard data sheets contain input cells for Upper and Lower Spec Limits. Input your spec limits here or use the defaults. Note: LSL and USL defaults are estimated as the average +/- 3*stdev (this differs from the XmR Five Pack and XbarR Six Pack templates which use Sigma Estimator.)

spec limits on Variable chart input sheets

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

xmr control chart dashboard

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.
arrows to toggle between charts
create dashboard icon

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

control chart dashboard excel

 

Tip - Custom Chart Formats: QI Macros dashboards are presentation ready. However, if you want to customize chart formats, save time using QI Macros "Remember Format and Apply Format" features. Just customize one chart, then select Remember Format and then Apply to All. Learn more...

Update Existing Charts

To add new data to your charts, go to the data input sheet and add your new data.

Then select the Refresh Charts or Refresh with Stability icon to update the charts and re-run stability analysis.

refresh stability analysis

Add new charts to an existing dashboard

You can add new charts to an existing dashboard manually:

  1. Add new data to Data Sheet.
  2. Select the sheet containing the type of chart you want to add.
  3. Use the Next/Previous buttons to get to the new chart you want to add.
  4. Right Click on the Sheet name and choose Move/Copy (Check the Create a Copy box). Click OK.
  5. Right Click on the new Chart and choose "Copy".
  6. Click on the Dashboard Sheet, Click on an empty cell and choose "Paste" to copy the chart into the dashboard.
  7. Reposition the new chart on the dashboard.

The July 2018 release of QI Macros adds a new button that will do steps 3-6 for you.

  1. Add new data to Data Sheet.
  2. Select the sheet containing the type of chart you want to add.
  3. Use the Next/Previous buttons to get to the new chart you want to add.
  4. Click on the "ADD THIS CHART TO DASHBOARD" button.
  5. Reposition the new chart on the dashboard..

You can also use this feature to create custom dashboards containing more than one kind of chart (e.g., c charts with p charts and u charts in the cpu Dashboard).


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