Scatter Plot Maker in Excel

Easily Create Scatter Plots in Excel Using QI Macros

scatter plot maker generates scatter diagrams in Excel

  1. Point - select your scatter plot data in an Excel worksheet
  2. Click - on the QI Macros Menu and choose the Scatter Plot
  3. Analyze and Improve - QI Macros will do the correlation calculations and draw a scatter plot in Excel for you.

If R² is greater than .80, there is a strong relationship between the two data sets. R² close to 1.0 means a perfect fit.

Example of Scatter Plot Diagram in Excel Created by QI Macros

scatter plot diagram in Excel

Scatterplot diagrams are used to evaluate the correlation or cause-effect relationship (if any) between two variables (e.g., speed and gas consumption in a vehicle).

When you think there's a cause-effect link between two indicators (e.g., calories consumed and weight gain) then you can use the scatter plot to prove or disprove it. If the points are tightly clustered along the trend line, then there's probably a strong correlation. If it looks more like a shotgun blast, there is no correlation.

Scatter Diagram with Strong Correlation

scatterplot with strong correlation

Scatter Diagram with No Correlation

Scatterplot with no correlation

Scatter Plot Diagrams can be made manually or in Excel. However, you have to find the right chart to get a trend line and Excel will not calculate the R² correlation of determination (square of the correlation coefficient) for you.

Use a Scatter Plot Maker like QI Macros for Excel to save time and get the calculations right.

Compatible with Excel 2003, 2007, 2010, 2013, 2011 (Mac)

Learn More...

To create a Scatter Plot Excel using QI Macros...
Try It Now!

Excelerate Your Projects Download Free QI Macros Trial Buy QI Macros for Excel Now