XbarR Chart Dashboard for Manufacturing using Excel

The purpose of the X bar R chart dashboard is to evaluate the stability of multiple measurements in a manufacturing environment.

Here is an example of the XbarR chart dashboard in QI Macros for Excel.

The XbarR dashboard has a few main components:

  • Data Entry Sheet
    Just type data into the yellow/white input areas on the data sheet. Use 2-5 samples:
  • xbarr-dashboard-1

  • XbarR Chart with flat limits for fixed sample sizes (2-5):
  • xbarr-dashboard-2

  • XbarR Chart with "skyline" limits for varying sample sizes (2-5):
  • xbarr-dashboard-3

Creating the XbarR Dashboard

  1. Input measurement titles, specification limits and data into the data sheet as shown above.
  2. Click on the XbarR, Skyline or Precontrol worksheet as shown above.
  3. Use the NEXT button to look through the various charts to make sure they are what you want.
  4. When you have the right data and charts, click on the CREATE DASHBOARD button to create the dashboard. This will create new worksheets for each chart as well as the dashboard showing just the X charts:
  5. XbarR Dashboard Charts

  6. Delete the XbarR Chart, Fixed Limits and Precontrol worksheets as they are no longer needed.
  7. You can rearange the charts on the dashboard by clicking and dragging them around.
  8. You can copy other charts from the new worksheets (e.g., Histograms) and paste them onto the dashboard:
  9. XbarR Dashboard with Added Charts

  10. You can then continue to add data to the data sheet and update charts by clicking the Refresh Charts or Refresh Charts with Stability buttons on the data sheet. Refresh with Stability will run QI Macros stability analysis on all control charts.
  11. If you save this workbook as an Excel "Shared" workbook, you could have multiple people updating various measurements. Just refresh the charts every so often. Anyone can then look at the dashboard.

I think you'll find this a very powerful feature of QI Macros. Creating dashboards of key measures quickly and easily. And keeping them up-to-date with a click of a button.

Learn More...

To create a X Bar R Dashboard using QI Macros...
Try It Now!