Home » Control Charts »

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:

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.

In any QI Macros versions released prior to July 2018, you would need to perform the "Add this Chart to Dashboard" option 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 - Keep Source Formatting" to copy the chart into the dashboard.
7. 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).

---

---

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:

1. 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":



2. Select and extend the formulas in row 101 to the number of additional rows you need:



3. Click on your chart in that tab, select "Add Data" from the QIMacros Chart section, and input how many rows you added:





4. Next, go to your Dashboard tab and click on the chart you added data to and repeat the same process listed in step 3:





5. Then, go to the Data Sheet tab and select either the "Refresh Charts" or "Refresh Charts w Stability" buttons:



6. 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

---