Funnel Plot in Excel

Funnel Plots help analyze companies, facilities or teams.

Funnel plots assist in comparing hospitals, healthcare teams and doctors to a target. Funnel-shaped "Control Limits" provide an estimate of quality.

QI Macros Six Sigma software for Excel includes two funnel plot options: percent and rate per 1000.

Percent Funnel Plot

Notice that most of the organizations lie within the limits which means that ranking and comparisons would not be useful. There are, however a few outside of the limits which could benefit from improvement.

Funnel Plot in Excel

Rate per 1000 Funnel Plot

rate per 1000 funnel plot

Funnel Plot Data Point Labels

The template defaults do not show labels on the data points. However, if you want to add labels to your data points just click on the "Add Labels to Data points" button in the lower right corner of the template.

labels on funnel plot

 

To create a Funnel Plot Excel Template using QI Macros...
Try It Now!