Scatter Plot Template in Excel

Drop in the Data and Template Draws a Scatter Plot

Scatter plots 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.

Example of QI Macros Scatter Plot Template in Excel

scatter plot worksheet for Excel

You can also switch the order of the X and Y axis!

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:


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