p Chart Dashboard for Excel

The purpose of the p Chart dashboard is to evaluate the stability of multiple patient safety measurements in a healthcare environment.

Here is an example of the p Chart dashboard in QI Macros for Excel using data from the Healthcare Data Guide.

The p Chart dashboard has a few main components: a data entry sheet and a p Chart template. There are also c, np and u Chart templates, but we'll stay with just the p Chart for this example. You cannot combine c, np, p and u Charts on the same dashboard automatically.

Data Entry Sheet
Just type data into the yellow/white input areas on the data sheet. Use a numerator and denominator for each measurement:

p chart dashboard data entry sheet

How to Create a p Chart Dashboard

  1. Input titles and data into the data sheet as shown above.
  2. Click on the P Chart tab to view the p chart template:
  3. CPU Dashboard Tab

    p chart dashboard template

  4. Use the Next/Prev buttons to toggle through your charts to make sure they are what you want:
  5. When you have the right data and charts, click on the CREATE DASHBOARD button. This will create new worksheets for each chart as well as the dashboard showing the p Charts:
  6. p Chart Dashboard

  7. Delete the C Chart, NP Chart, U Chart and Run Chart tabs, as they are no longer needed.
  8. You can rearrange the charts on the dashboard by clicking and dragging them around.
  9. You can then continue to add data to the data sheet and update charts by clicking the "Refresh Charts," "Refresh Charts w Stability," or "Refresh Charts w Rules" buttons on the data sheet. Refresh with Stability will run QI Macros stability analysis on all control charts. Refresh Charts with Rules will run QI Macros stability analysis on all control charts and show specific rules violated.
  10. 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.

NOTE: The Show Process Change and Fix Control Limits tools are functional in the np, p and u Dashboards, starting with the April 2021 release. However, these tools are not functional in previous QI Macros releases.

Different Ways to Customize your Dashboard

Learn More...

Top Reasons to Choose QI Macros to Create Control Charts

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



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