excel sparkline

Excel: Sparkline

Inline mini-charts embedded within worksheet cells.

Path: /{SheetName}/sparkline[N]

Operations

• add - Insert a sparkline

get

officecli get data.xlsx /Sheet1/sparkline[1]

set

Property	Accepted Values	Description
type	line, column, stacked	Sparkline type
color	hex RGB	Main color
negativecolor	hex RGB	Negative value color
markers	bool	Show data point markers
highpoint	hex RGB	High point marker color
lowpoint	hex RGB	Low point marker color
firstpoint	hex RGB	First point marker color
lastpoint	hex RGB	Last point marker color
negative	hex RGB	Negative point marker color
lineweight	number	Line weight (for line type)

officecli set data.xlsx /Sheet1/sparkline[1] --prop type=column --prop color=4472C4
officecli set data.xlsx /Sheet1/sparkline[1] --prop markers=true --prop highpoint=FF0000

remove

officecli remove data.xlsx /Sheet1/sparkline[1]

See Also

• Sparkline add - Insert sparklines
• Excel Reference - All Excel elements

---

Based on OfficeCLI v1.0.38