How to Choose the Right Six Sigma Chart

There are so many different kinds of charts used in Six Sigma and SPC for Excel. How do you choose the right chart ? One of our customers asked for a "cheat sheet" so here it is.

If your data is organized by... And your data looks like this in Excel... Choose one of these charts...
Category 
(e.g., type of defect, city, state, country, male/female, etc.)
Headings + Integers or Decimals:

Pareto Chart
Six Sigma pareto chart 
Bar Chart
Six Sigma bar chart

Cause and effect 
(e.g., calories vs weight gained, variation vs warranty claims, etc.)
Two columns/rows of numbers:

Scatter Chart
Six Sigma scatter chart
Matrix Plot

Time
Attribute Data
(days, hours, batch number, lot number, etc.)
One column of Integers

c Chart
SPC chart - c chart

Time

Attribute Data
(Counted)
Headers (time, lot number)
1. Defects (Integer)
2. Sample size (contant integer)

np Chart
Six Sigma chart - np chart

Time
Attribute Data
(Counted)
Headers
1. Defective items (Integer)
2. Sample size (variable integer)

p Chart
SPC chart - p chart

Time

Attribute Data

(Counted)

Headers
1. Defects (Integer)
2. Sample size (variable integer)

u Chart
Six Sigma chart - u chart

Time

Variable Data

(Measured)

Headers (time, lot number)
1. Decimals, Percentages, Ratios

XmR Chart
SPC chart - XmR chart

Histogram
Six Sigma chart - Histogram

Time

Variable Data

(Measured)
Headers (time, lot number)
2-5 columns of Decimals

XbarR Chart
XMedianR
Six Sigma chart - XbarR chart

Histogram
SPC chart - Histogram

Time

Variable Data

(Measured)
Headers (time, lot number)
5-25 columns of Decimals

XBarS Chart
SPC chart - XbarS chart

Histogram
Six Sigma chart - Histogram

Create these charts and diagrams in just seconds using QI Macros for Excel...