Ways to Utilize the Control Chart Dashboard Features

Your QI Macros Dashboards Can be Customized!


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:

dashboard-buttons


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. add-chart-to-dashboard

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


How do I create a Histogram Dashboard?

This functionality is available for the XmR and XbarR Dashboards ONLY

  1.  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.
  2. Select the Previous button to get to the very first chart in your data set.
  3. Next, select the "Create Histogram Dashboard" button:
  4. 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)

conditional-formatting-histogram-dashboard


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.):

y-axis-multiplier


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. dashboard expand calculations

  3. Select and extend the formulas in row 101 to the number of additional rows you need:
  4. expand calculations down

  5. Click on your chart in that tab, select "Add Data" from the QIMacros Chart section, and input how many rows you added:
  6. add data to charts

    add data prompt

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

    add data prompt

  9. Then, go to the Data Sheet tab and select either the "Refresh Charts" or "Refresh Charts w Stability" buttons:
  10. refresh charts button Dashboard Refresh with Stability Analysis Button

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


easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free

affordable

Affordable

  • Only $329 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support