Repository navigation
excel chart set
goworm edited this page Jul 9, 2026
·
58 revisions
Modify an existing chart's properties.
Path: /{SheetName}/chart[N]
| Property | Accepted Values | Description |
|---|---|---|
title |
string, or cell reference | Update chart title. A bare (Sheet1!A1) or =-prefixed (=Sheet1!A1, v1.0.133+) cell reference links the title to that cell's value instead of writing literal text; applies to axis titles too. |
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. (v1.0.131+) dataLabels.position / dataLabels.pos / dataLabels.labelpos are accepted aliases, routed through the same setter. |
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 |
referenceLine/refLine
|
value or "value:color:width:dash"
|
Reference/target line |
colorRule/conditionalColor
|
rule expression | Conditional coloring for data points |
smooth |
bool | Smooth line curves (line/scatter) |
showMarker/showMarkers
|
bool | Toggle markers on line charts |
dropLines |
bool | Show vertical drop lines from data points to X axis (line charts) |
hiLowLines |
bool | Show high-low lines connecting highest/lowest series values (line/stock) |
upDownBars |
bool | Show gain/loss bars between first and last series (line/stock) |
serLines/seriesLines
|
bool | Show series connector lines (stacked bar/pie-of-pie) |
dataTable |
bool | Show data table below chart |
roundedCorners |
bool | Rounded corners on chart area |
preset/theme
|
preset name | Chart style preset |
plotArea.x/y/w/h |
decimal (0-1) | Manual layout of plot area |
title.x/y/w/h |
decimal (0-1) | Manual layout of chart title |
legend.x/y/w/h |
decimal (0-1) | Manual layout of legend |
legend.overlay |
bool | Legend overlays chart area |
dataLabel{N}.text |
string | Custom text for data label N |
dataLabel{N}.x/y/w/h |
decimal (0-1) | Manual layout of data label N |
dataLabel{N}.delete |
bool | Hide/show individual data label |
dataLabels.separator |
string | Label separator |
dataLabels.numFmt |
format code | Label number format (e.g., "0.0%") |
series{N}.name |
string | Update series name |
series{N}.values |
comma-separated or cell range | Update series values |
axisLine/axis.line
|
"color:width:dash" |
Value axis line styling |
catAxisLine |
"color:width:dash" |
Category axis line styling |
axisVisible/axis.visible
|
bool | Hide/show axes |
majorTickMark/majorTick
|
tick style | Major tick mark style |
minorTickMark/minorTick
|
tick style | Minor tick mark style |
tickLabelPos |
position | Tick label position |
axisOrientation/axisReverse
|
bool | Reverse axis direction |
logBase/logScale
|
number | Logarithmic scale base |
dispUnits/displayUnits
|
thousands, millions, etc. |
Display units |
point{N}.color |
hex color | Individual data point color |
invertIfNeg |
bool | Invert bars for negative values |
explosion/explode
|
0-400 | Pie slice explosion (%) |
errBars/errorBars
|
error bar type | Error bars |
autotitledeleted |
bool | Suppress the auto-generated "Chart Title" placeholder |
axisposition/axispos
|
tick/cross keyword | Convenience shortcut for axis tickLabelPos/crossBetween (see chart-axis for full options) |
crossesAt |
number | Value-axis crossing point |
gapdepth |
number | Depth gap between series in 3D bar/line/area charts (percent) |
plotvisonly/plotvisibleonly
|
bool | If true, skip plotting hidden worksheet rows/columns |
title.overlay/titleoverlay
|
bool | If true, title overlays the plot area instead of reserving space above it |
chartArea.border/chartBorder
|
border format | Chart area border |
plotArea.border/plotBorder
|
border format | Plot area border |
x, y
|
EMU or units | Chart position (top-left corner) |
width, height
|
EMU or units | Chart size |
anchor |
range (e.g. F5:N25) |
Move + resize the chart in place by mutating its TwoCellAnchor. Takes precedence over x/y/width/height (mirrors chart Add). Works on standard and extended charts (pareto/histogram/…). Series remain immutable after create — use remove + add. |
Extended chart types (cx:chart — histogram, funnel, treemap, sunburst, boxWhisker):
All properties above are supported on extended charts via the same set command, plus each cx type has its own knob vocabulary. For the complete histogram vocabulary (binning + styling + layout + axis scaling + plot/chart area fills + shadows + legend + data labels), see the dedicated page:
- excel-chart-histogram — full cx histogram reference
Other cx types keep their specific knobs (parentLabelLayout for treemap, quartileMethod for boxWhisker) and share the same cx styling vocabulary documented on the histogram page.
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"
# Manual layout
officecli set data.xlsx /Sheet1/chart[1] --prop plotArea.x=0.1 --prop plotArea.y=0.15 --prop plotArea.w=0.8 --prop plotArea.h=0.7
# Reference line
officecli set data.xlsx /Sheet1/chart[1] --prop referenceLine="75:FF0000:1.5:dash"
# Custom data label
officecli set data.xlsx /Sheet1/chart[1] --prop dataLabel1.text="Peak" --prop dataLabel1.x=0.5 --prop dataLabel1.y=0.1
# Update series name and values
officecli set data.xlsx /Sheet1/chart[1] --prop series1.name="Revenue 2026" --prop series1.values="100,200,300,400"
# Axis styling
officecli set data.xlsx /Sheet1/chart[1] --prop axisLine="333333:1:solid" --prop majorTickMark=outsideBased on OfficeCLI v1.0.133
