Course / Charts

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

  1. Ten weeks of advertising and the sales that followed. Select A1:B11, click Chart, choose Scatter, and click Insert.

  2. 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.

  3. The chart says the two are linked. Put a number on how closely: in B13, enter =CORREL(A2:A11, B2:B11).

  4. Finish it with a title. Under Chart title, type Sales against ad spend.

Remember

In the function reference: CORREL

Previous: Pie charts, and when not to use one · Next: Trendlines and forecasts