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

Why Choose QI Macros Over Other Control Chart Software?

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