excel chart bubble

Excel: Chart - bubble

A dedicated page for the bubble chart type. Bubble charts extend scatter plots with a third dimension: each data point is drawn as a circle whose size represents an additional variable.

Path: /{SheetName}/chart[N]

See also: Chart - add, Chart - set.

Bubble-specific properties

Bubble scale

Property	Default	Notes
bubbleScale	100	Scale factor for bubble sizes (50-500, as %)

officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=bubble \
  --prop title="Market Analysis" \
  --prop categories="10,20,30,40" \
  --prop series1="Products:100,200,150,300"

# Smaller bubbles
officecli set data.xlsx /Sheet1/chart[1] --prop bubbleScale=60

Size representation

Property	Default	Notes
sizeRepresents	width	How bubble size maps to value: width or area

officecli set data.xlsx /Sheet1/chart[1] --prop sizeRepresents=area

Negative bubbles

Property	Default	Notes
showNegBubbles	true	Show bubbles for negative values

Bubble size labels

Property	Default	Notes
dataLabels.showBubbleSize	false	Show bubble size value as label

Data format

Bubble charts use three values per point:

• X (from categories): horizontal position
• Y (from series values): vertical position
• Size (from series values or third column): bubble diameter

officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=bubble \
  --prop title="Portfolio" \
  --prop categories="10,20,30" \
  --prop series1="Fund A:100,200,150" \
  --prop bubbleScale=80

HTML preview support

Feature	Preview	Notes
XY positioning	Yes	Numeric axes
Bubble sizing	Yes	Scaled by bubbleScale
Grid and axes	Yes

See Also

• Chart - Overview
• Chart add - Add a chart

---

Based on OfficeCLI v1.0.43