Ways to Utilize the Control Chart Dashboard Features
Your QI Macros Dashboards Can be Customized!
- How do I update my existing Dashboard charts?
- How do I add new charts to an existing Dashboard?
- How do I create a Histogram Dashboard?
- How can I change the Y-Axis Multiplier in my p and u Chart Dashboards?
- How do I add more than 100 rows of data to my Dashboard?
- Why am I recieving a "Reference Invalid" message?
How do I update my existing Dashboard 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:
How do I add new charts to an existing Dashboard?
You can add new charts to an existing dashboard:
- Add new data to Data Sheet.
- Select the sheet containing the type of chart you want to add.
- Use the Next/Previous buttons to get to the new chart you want to add.
- Click on the "ADD THIS CHART TO DASHBOARD" button:
- Reposition the new chart on the dashboard.
In any QI Macros versions released prior to July 2018, you would need to perform the "Add this Chart to Dashboard" option manually:
- Add new data to Data Sheet.
- Select the sheet containing the type of chart you want to add.
- Use the Next/Previous buttons to get to the new chart you want to add.
- Right Click on the Sheet name and choose Move/Copy (Check the Create a Copy box). Click OK.
- Right Click on the new Chart and choose "Copy".
- Click on the Dashboard Sheet, Click on an empty cell and choose "Paste - Keep Source Formatting" to copy the chart into the dashboard.
- 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).
How do I create a Histogram Dashboard?
This functionality is available for the XmR and XbarR Dashboards ONLY
- If you would like to create a Histogram Dashboard, based upon your data set, select the sheet containing the type of chart dashboard you created.
- Select the Previous button to get to the very first chart in your data set.
- Next, select the "Create Histogram Dashboard" button:

NOTE: Conditional Formatting is applied to Cp Cpk and Pp Ppk metrics when values are as follows:
Red: Under 1.00 (Not capable)
Yellow: 1.00 - 1.33 (Will not meet most manufacturing specifications)
White: 1.34 - 1.66 (Capable)
Green: 1.67 and up (Approaching Five Sigma to Six Sigma - Exceptional)
How do I change the Y-Axis Multiplier in my p and u Chart Dashboards?
- Specific to the p and u Chart Dashboard, the Multiplier is located to the right of your chart, this functionality allows you to change the multiplier. This automatically changes the y-axis value (e.g. 1, 10, 100, etc.):
Need to add more than 100 rows of data?
Dashboards only provide up to 100 rows of data calculations. If you have more than 100 rows, you will need to manually extend the formulas and use our "Add Data" functionality - see instructions below:
- For any charts requiring more than 100 rows of data, go into each control chart tab created after your Dashboard was developed. Next, unfilter your data by selecting the Filter button > "Select All" > "OK":
- Select and extend the formulas in row 101 to the number of additional rows you need:
- Click on your chart in that tab, select "Add Data" from the QIMacros Chart section, and input how many rows you added:
- Next, go to your Dashboard tab and click on the chart you added data to and repeat the same process listed in step 3:
- Then, go to the Data Sheet tab and select either the "Refresh Charts" or "Refresh Charts w Stability" buttons:
- Your Dashboard will now be updated to include your extra data!
Why am I recieving a "Reference Invalid" message?
If you receive a "Reference Invalid" message with a Control Chart Dashboard opened, this is because AutoSave is enabled in your Excel. Note that it is not possible to use AutoSave with a macro-enabled workbook.
To no longer receive this message, disable AutoSave when working with a macro-enabled workbook, such as our Control Chart Dashboard.
Learn More...
- cpu Dashboard
- Levey Jennings Dashboard
- p Chart Dashboard
- u Chart Dashboard
- XbarR Dashboard
- XmR Dashboard
Fast and Easy to Use
- Works right in Excel
- Create charts in seconds
- Easy to customize & share charts
- Free Training Anytime
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free
Affordable
- Only $349 USD
Quantity Discounts Available - No annual subscription fees
- Free technical support