Paste an X column and a Y column. The trend line is fitted by least squares and its equation and R² are shown under the chart. No account, and the data stays in your browser.
How to make a scatter plot
- Put one observation in each row: a person, a day, a product.
- Put the X values in the first number column and the Y values in the next. A text column in front, with a name for each row, is optional.
- Paste the cells in the Data panel. Each row becomes a point.
- Name both axes, with units. A scatter plot without axis titles cannot be read.
- Turn on the trend line if you want the fitted straight line and its R².
Reading the trend line
The line is fitted by least squares, and its equation is shown under the chart as y = slope × x + intercept. The slope says how much Y changes, on average, when X grows by one unit. R² runs from 0 to 1 and measures how closely the points follow the line.
Three cautions apply to any fitted line:
- It describes, it does not explain. Points that rise together may both depend on something that is not in the table.
- It is straight. A clear curve can have a low R². Look at the points before trusting the number.
- It holds inside the data. Extending the line beyond the smallest or largest X is a guess.
Which variable goes on X
By convention X is the measure you set or that comes first (dose, time spent, price), and Y is the one that responds (effect, score, sales). If neither depends on the other, either order is fine; the trend line will differ, because it measures vertical distances.
Axes
Both axes get round tick marks from the data. With “Start the axis at zero” on, both include zero, which keeps proportions honest; turn it off when the points sit in a narrow band far from zero and would otherwise be squeezed into a corner.
If your X values are evenly spaced dates, a line graph is simpler to read. To compare a handful of named items on one measure, use a bar chart.