How to Make a Scatter Plot in Excel

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

    scatter plot data to make a scatter plot

  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 trendline type

You can also create a scatter plot in Excel using QI Macros

Create these charts and diagrams in just seconds using QI Macros for Excel...
Try It Now!