How to Create a Scatter Chart
Data Format
One row per point.
| Label | X | Y | Group |
|---|---|---|---|
| Acme Corp | 12 | 45 | Region A |
| Globex | 18 | 30 | Region B |
| Initech | 9 | 52 | Region A |
- Label (optional): text shown next to the point.
- X, Y (required, numeric): point position. A row with a missing or non-numeric X or Y is dropped.
- Group (optional): assigns a category. Drives point color and the legend.
Adding a Z column turns points into sized bubbles, see the Bubble Chart guide.
Chart Elements
Every part of the chart maps to a section in the style panel.
Points
Every point renders as a dot of fixed size.
- Color - single color for all points, or a per-group color row once the Group column is used.
- Dot size - fixed radius for every point.
Point Labels
Shows the Label column text next to each point. Can be hidden entirely.
- Color - text color.
- Font - font family and weight.
- Font Size - text size.
Axes
X and Y are styled independently, each with its own range, tick count, color, and visibility.
- X Min / X Max - override the auto-calculated X range.
- Y Min / Y Max - override the auto-calculated Y range.
- X Ticks / Y Ticks - how many ticks appear on each axis.
- X Color / Y Color - axis line color.
- X Axis / Y Axis - show or hide each axis line.
Gridlines
X and Y gridlines share one color and thickness setting, but can be shown or hidden independently.
- Color - applies to both X and Y gridlines.
- Thickness - applies to both X and Y gridlines.
- X Grid / Y Grid - show or hide each independently.
Axis Tick Labels
The numbers along each axis share one color and font, but number formatting is set independently per axis.
- Color - applies to both axes.
- Font / Font Size - applies to both axes.
- Prefix / Suffix - set independently for X and Y (e.g. "$", "%").
- Rotation - set independently for X and Y.
- X Labels / Y Labels - show or hide each independently.
Legend
Appears automatically once any point has a Group value. Can be hidden independently of the grouping itself.
- Position - Top, Bottom, Right, or Direct (label placed next to each group's points instead of a separate legend box).
- Color - legend text color.
- Font / Font Size - legend text styling.