Create Control Chart Dashboards 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?

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

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 QI Macros menu and open one of the four available dashboards: c, p, u, np attribute charts, Levey Jennings, XmR or XbarR Dashboard.

Excel and Mac

control chart dashboard mac menu

Excel 2007-2016

control chart dashboard menu

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

c, np, p, u Dashboard Template

Levey Jennings Dashboard Template

XmR 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 these chart titles to name sheets when the dashboard is created, make these names unique and limit them to 31 characters.

data input sheet


XmR Dashboard Data Sheet

Rows 1 and 2 of the XmR and XbarR dashboard data sheets 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 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.

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

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


To add new data to your charts, just go to the data input sheet and add your new data. Then select the:

Refresh Charts icon to update the charts.

Refresh with Stability icon to update the charts and re-run stability analysis.

refresh charts

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.

To create a Control Chart Dashboard using QI Macros...
Try It Now!