How to Create a Bubble Chart
Data Format
One row per bubble.
| Label | X | Y | Z (bubble size) | Group |
|---|---|---|---|---|
| Acme Corp | 12 | 45 | 8 | Region A |
| Globex | 18 | 30 | 15 | Region B |
| Initech | 9 | 52 | 4 | Region A |
- Label (optional): text shown next to the bubble.
- X, Y (required, numeric): point position. A row with a missing or non-numeric X or Y is dropped.
- Z (bubble size) (required, ≥ 0, to size every point): once any row has a Z value, the whole chart switches to bubble mode and sizes every point relative to the largest Z in the data. Rows without a Z value render at radius 0 (invisible).
- Group (optional): assigns a category. Drives bubble color and the legend, independent of size.
Chart Elements
Every part of the chart maps to a section in the style panel.
Bubbles
Every point renders as a bubble sized by its Z value, relative to the largest Z in the data.
- Color - single color for all bubbles, or a per-group color row once the Group column is used.
- Bubble size - a multiplier scaling every bubble relative to their Z value.
Point Labels
Shows the Label column text next to each bubble. Can be hidden entirely.
- Color - text color.
- Font - font family and weight.
- Font Size - text size.
Value Labels
Shows the Z value inside each bubble. Only appears if the bubble is large enough to fit the text.
- 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 bubble has a Group value. Independent of bubble size. 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.