excel chart scatter

Excel: Chart - scatter

A dedicated page for the scatter (XY) chart type. Scatter charts plot data points using numeric X and Y coordinates, making them ideal for correlation analysis, distribution plots, and scientific data.

Path: /{SheetName}/chart[N]

See also: Chart - add, Chart - set.

Chart type variants

Type string	Aliases
scatter	xy

Scatter-specific properties

Scatter style

Property	Default	Notes
scatterStyle	lineMarker	Visual connection between points

Style	Description
marker	Points only (no connecting lines)
line	Lines only (no markers)
lineMarker	Lines with markers (default)
smooth	Smooth curves only
smoothMarker	Smooth curves with markers

officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=scatter \
  --prop scatterStyle=smooth \
  --prop title="Correlation" \
  --prop categories="1,2,3,4,5" \
  --prop series1="Y:2,4,5,8,10"

officecli set data.xlsx /Sheet1/chart[1] --prop scatterStyle=marker

Data format

Scatter charts use numeric X values (from categories) and Y values (from series data). Both axes are value axes.

# X values as categories, Y values as series
officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=scatter \
  --prop categories="10,20,30,40,50" \
  --prop series1="Revenue:100,200,350,420,500" \
  --prop series2="Profit:20,50,80,100,130"

HTML preview support

Feature	Preview	Notes
XY point rendering	Yes	Numeric X/Y axes
Line connections	Yes
Markers	Yes	All 10 shapes
Smooth curves	Yes	Catmull-Rom spline

See Also

• Chart - Overview
• Chart add - Add a chart

---

Based on OfficeCLI v1.0.43