How to Create a Bubble Chart

Data Format

One row per bubble.

LabelXYZ (bubble size)Group
Acme Corp12458Region A
Globex183015Region B
Initech9524Region 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.

Ready to Build Your Own?