How to Make a Scatter Plot in Excel

How to Make a Scatter Plot

1. Collect 20 or more paired data samples. See scatter plot data example below:

   

2. Label the "effect" variable on left-hand (Y) axis.
3. Label the suspected "cause" variable on the bottom (X) axis.
4. Plot all of the paired points (the QI Macros will do this for you).
5. Analyze the graph for relationships among the variables.

You can also change the trend line to show other distributions. Double click on the trend line and select from one of the other available distributions: logarithmic, Polynomial, Power, Exponential, or Moving Average.

• Scatter Plot in Excel
• Scatter Plot Examples
• Scatter Plot Matrix
• Watch video showing how to create a Scatter Plot in Excel using the QI Macros

The Scatter Plot with correlation metrics is just one of the tools included in the QI Macros for Excel SPC Software.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma