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