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, gradient "C1-C2[:angle]", or "none"	Plot area background
chartFill/chartAreaFill	hex color, gradient "C1-C2[:angle]", or "none"	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
title.font/titlefont	font name	Title typeface
title.size/titlesize	number (pt)	Title font size
title.color/titlecolor	hex color	Title font color
title.bold/titlebold	true/false	Title bold
title.glow/titleglow	"COLOR-RADIUS-OPACITY" or "none"	Title glow effect
title.shadow/titleshadow	"COLOR-BLUR-ANGLE-DIST-OPACITY" or "none"	Title shadow effect
legendfont/legend.font	"size:color:fontname"	Legend font e.g. "9:8B949E:Helvetica Neue"
axisfont/axis.font	"size:color:fontname"	Axis label font e.g. "10:58626E:Arial"
series.shadow/seriesshadow	"COLOR-BLUR-ANGLE-DIST-OPACITY" or "none"	Shadow on series
series.outline/seriesoutline	"COLOR-WIDTH" or "none"	Series outline e.g. "FFFFFF-0.5"
gapwidth/gap	0-500	Bar gap width
overlap	-100 to 100	Bar overlap
view3d/camera/perspective	"rotX,rotY,perspective"	3D rotation e.g. "15,20,30"
areafill/area.fill	"C1-C2[:angle]"	Area gradient fill

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"

# Format chart title
officecli set data.xlsx /Sheet1/chart[1] --prop title.font=Arial --prop title.size=16 --prop title.bold=true

# Add legend font
officecli set data.xlsx /Sheet1/chart[1] --prop legendfont="9:8B949E:Helvetica Neue"

# 3D perspective
officecli set data.xlsx /Sheet1/chart[1] --prop view3d="15,20,30"

# Series outline
officecli set data.xlsx /Sheet1/chart[1] --prop series.outline="FFFFFF-0.5"

---

Based on OfficeCLI v1.0.18