g Chart Template for Excel to Track Rare Events

The g chart is also known as the geometric means chart

QI Macros add-in contains an easy to use g chart template with many options

To create a g chart, just drop your data into the input area and QI Macros does the rest.

g chart template excel


g Chart Template Options

The template is flexible enough to handle different kinds of data.

Days Between Events

Input dates, then days between are calculated

input dates of rare events

Units Between Events

Input number of units (e.g surgeries, shifts) between events

input units between events


QI Macros also contains a g chart Gunston - Missed vs Met

In the yellow input area, track each period (day/week/month) where you met or missed an objective (e.g., no accidents). The template will calculate the number of days met/missed and the control limits. On any given day, the business either:

  • Met the objective (no accidents)
  • Missed the objective (accident)
  • No data (forgot to track the information)

g chart missed vs met

Examples of Rare Event Data where a g chart would be useful

  • Admissions between infections
  • Discharges between readmissions
  • Patients between complications
  • Days between adverse drug events
  • Days between needle sticks

Learn More...

  • g Chart formula
  • g Chart Overview
  • Other Variable Control Charts in Excel

  • Why Choose QI Macros Over Other Control Chart Software?

    affordable

    Affordable

    • Only $279 USD - less with quantity discounts
    • No annual subscription fees
    • Free technical support

    easy to use

    Easy to Use

    • Works right in Excel
    • Create a chart in seconds
    • Easy to customize & share charts

    proven and trusted

    Proven and Trusted

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