excel chart set

Excel: Chart - set

Modify an existing chart's properties.

Path: /{SheetName}/chart[N]

Properties

Property	Accepted Values	Description
title	string	Update chart title
legend	position keyword	Update legend position
catTitle / hTitle	string	Update category axis title
axisTitle / vTitle	string	Update value axis title
dataLabels / labels	comma-separated: value,category,series,percent,all,none,true	Configure data labels
colors	comma-separated hex RGB	Update color palette
axisMin / min	number	Minimum value for value axis
axisMax / max	number	Maximum value for value axis
majorUnit	number	Major unit interval for value axis
minorUnit	number	Minor unit interval for value axis
axisNumFmt / axisNumberFormat	format code	Number format for value axis
categories	comma-separated	Update category labels
data	Series1:1,2,3;Series2:4,5,6	Update all series data
series1..seriesN	Name:val1,val2	Update individual series
labelPos/labelposition	position keyword	Label position: center/ctr, insideEnd/inside, insideBase/base, outsideEnd/outside, bestFit/best/auto, top/t, bottom/b, left/l, right/r
labelFont	"size:color:bold"	Label font e.g. "10:FF0000:true"
gridlines/majorGridlines	true, none/false, or "color:widthPt:dash"	Major gridlines configuration
minorGridlines	same as gridlines	Minor gridlines configuration
plotFill/plotAreaFill	hex color	Plot area background
chartFill/chartAreaFill	hex color	Chart area background
lineWidth	number (pt)	Line width in pt
lineDash/dash	dash style keyword	solid, dot, dash, dashdot, longdash, longdashdot, longdashdotdot
marker/markers	"style:size:color"	Marker config e.g. "circle:8:FF0000". Styles: circle, diamond, square, triangle, star, x, plus, dash, dot, none
style/styleId	1-48 or none	Chart style
transparency	0-100	Series transparency (%)
opacity/alpha	0-100	Series opacity (%)
gradient	"color1-color2:angle"	Gradient fill
gradients	semicolon-separated	Per-series gradients
secondaryAxis/secondary	comma-separated indices	1-based series indices for secondary axis

Examples

officecli set data.xlsx /Sheet1/chart[1] --prop title="Updated Sales Chart"
officecli set data.xlsx /Sheet1/chart[1] --prop legend=bottom
officecli set data.xlsx /Sheet1/chart[1] --prop catTitle="Month" --prop axisTitle="Revenue"

---

Based on OfficeCli v1.0.9