Scatter Plot Maker in Excel
Easily Create Scatter Plots in Excel Using QI Macros
- Point - select your scatter plot data in an Excel worksheet
- Click - on the QI Macros Menu and choose the Scatter Plot
- 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 an Excel Scatter Plot Diagram Created by QI Macros
Scatter Plot 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
Scatter Diagram 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 2010-2019/Office 365 (PC) | 2016, 2019/Office 365 (Mac)
You can also switch the order of the X and Y axis and add/remove Confidence and Prediction Intervals!
In the Scatter Template, once you have created your chart, you can switch the X and Y-Axis by inputting "1" or "2" in the "Order" section to the right of your chart. Once you have typed in 1 or 2, press Enter and your Chart will update automatically. You can also show the Confidence Interval (CI) and Prediction Interval (PI) by inputting "True" in the "Show CI/PI" section or hide by inputting "False":
Confidence Intervals: Provide a view into the uncertainty when estimating the mean.
Prediction Intervals: Account for variation in the Y values around the mean.
Want to create an XY Scatter Diagram with Four Quadrants? See instructions below:
Although QI Macros does not offer this specific diagram, you can create one with the combination of our software and Excel's functionality.
1.) Create your Scatter Diagram:
2.) Next, delete the trend line from your diagram:
3.) Once the diagram has been created, right-click on your X-Axis, and select "Format Axis":
4.) Next, update your Axis Value which will place the X-Axis in the middle of your diagram, depending on the value you choose:
5.) Then, right-click on your Y-Axis, and select "Format Axis":
6.) Update your Axis Value which will place the Y-Axis in the middle of your diagram, depending on the value you choose:
7.) Once you have updated both the X and Y Axis Values, you have now created an XY Scatter Diagram with Four Quadrants!
- Watch video showing how to create a Scatterplot in Excel using the QI Macros
- Scatter Diagram Examples
- Scatter Plot Matrix for more than two variables