Scatter charts for relationships
Plot one set of numbers against another, name both axes, and put a figure on the link with CORREL. Intermediate · 5 min · Scatter chart, Axis titles, CORREL
A scatter chart plots one set of numbers against another: each row of the data becomes one dot, placed by its two values.
It answers do these two things move together? Dots that climb from left to right mean that when one goes up, so does the other. A shapeless cloud means no link.
It is the only chart in this track where both axes are numbers. The first column goes along the bottom and the second up the side, so put the thing you control (here, ad spend) first.
Steps
Ten weeks of advertising and the sales that followed. Select
A1:B11, click Chart, choose Scatter, and click Insert.With two axes of numbers, nobody can tell which is which without labels. In the Chart panel, set Horizontal axis title to Ad spend and Vertical axis title to Sales.
The chart says the two are linked. Put a number on how closely: in
B13, enter=CORREL(A2:A11, B2:B11).Finish it with a title. Under Chart title, type Sales against ad spend.
Remember
- A scatter chart plots two columns of numbers against each other, one dot per row.
- The first column goes along the bottom, the second up the side.
- Always give both axes a title.
CORRELputs a number on what the chart shows: near 1, the two rise together.
In the function reference: CORREL
Previous: Pie charts, and when not to use one · Next: Trendlines and forecasts