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 data

Pareto Chart
pareto chart 
Bar Chart
bar chart

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

Scatter Chart
Six Sigma scatter chart
Matrix Plot
matrix plot

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

c Chart
c chart

Time

Attribute Data
(Counted)
Headers (time, lot number)
1. Defects (Integer)
2. Sample size (constant integer)
np chart data

np Chart
np chart

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

Time

Attribute Data

(Counted)

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

u Chart
u chart

Time

Variable Data

(Measured)

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

XmR Chart
XmR chart

Histogram
histogram

Time

Variable Data

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

XbarR Chart
XMedianR
XbarR chart

Histogram
histogram

Time

Variable Data

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

XBarS Chart
XbarS chart

Histogram
histogram

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