Scatter & Bubble Charts
Available since version 1.6.
Scatter Charts
Scatter charts plot data as individual x/y coordinate pairs. Each dataset requires two columns (or rows) of numeric data — one for the x values and one for the y values and each column or row should start with a label.
| Label 1 (x) | Label 2 (y) |
| 10 | 5 |
| 20 | 15 |
| 30 | 25 |
Or alternately you could format the data with an additional label for each data point as a whole.
| Label 1 (x) | Label 2 (y) | |
| Something 1 | 10 | 5 |
| Something 2 | 20 | 15 |
| Something 3 | 30 | 25 |
Bubble Charts
Bubble charts extend scatter charts with a third dimension — bubble size (radius). Each dataset requires three columns (or rows): x, y, and radius.
| Label 1 (x) | Label 2 (y) | Label 3 (radius) |
| 10 | 5 | 95 |
| 20 | 15 | 75 |
| 30 | 25 | 30 |
The first column is x, the second is y, the third is the bubble radius value.
Or just like with scatter charts you could include an additional label for each data point as a whole.
| Label 1 (x) | Label 2 (y) | Label 3 (radius) | |
| Something 1 | 10 | 5 | 95 |
| Something 2 | 20 | 15 | 75 |
| Something 3 | 30 | 25 | 30 |
Bubble Sizing
Bubble radii are automatically scaled relative to each other so they fit the chart area. The tooltip will show the original (pre-scaled) value.
Multiple Sheets
Scatter and bubble charts support multiple datasets via the sheet tab interface. Each sheet represents a separate dataset/series plotted on the same chart.