# 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!

### Learn More...

- 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