-
Notifications
You must be signed in to change notification settings - Fork 1.1k
word chart set
goworm edited this page Jun 26, 2026
·
53 revisions
Modify chart title, legend, and other properties.
Path: /chart[N]
| Property | Default | Description |
|---|---|---|
title |
- | Chart title (text) |
legend |
- |
true, false, top, bottom, left, right, none
|
dataLabels/labels
|
- | Show data labels (bool) |
colors |
- | Comma-separated hex colors |
axisTitle/vTitle
|
- | Value axis title (text) |
catTitle/hTitle
|
- | Category axis title (text) |
axisMin/min
|
- | Value axis minimum (number) |
axisMax/max
|
- | Value axis maximum (number) |
majorUnit |
- | Major unit interval (number) |
minorUnit |
- | Minor unit interval (number) |
axisNumFmt |
- | Axis number format code |
categories |
- | Comma-separated category labels |
data |
- | Series data (Series1:1,2,3;Series2:4,5,6) |
series1..seriesN
|
- | Individual series (Name:val1,val2) |
labelPos/labelposition
|
- | Label position: center/ctr, insideEnd/inside, insideBase/base, outsideEnd/outside, bestFit/best/auto, top/t, bottom/b, left/l, right/r
|
labelFont |
- | Label font: "size:color:bold" e.g. "10:FF0000:true"
|
gridlines/majorGridlines
|
- |
true, none/false, or "color:widthPt:dash"
|
minorGridlines |
- | Same format as gridlines
|
plotFill/plotAreaFill
|
- | Plot area background: hex color, gradient "C1-C2[:angle]", or "none"
|
chartFill/chartAreaFill
|
- | Chart area background: hex color, gradient "C1-C2[:angle]", or "none"
|
lineWidth |
- | Line width in pt |
lineDash/dash
|
- |
solid, dot, dash, dashdot, longdash, longdashdot, longdashdotdot
|
marker/markers
|
- |
"style:size:color" e.g. "circle:8:FF0000". Styles: circle, diamond, square, triangle, star, x, plus, dash, dot, none
|
style/styleId
|
- | Chart style (1-48, or none) |
transparency |
- | Series transparency (0-100%) |
opacity/alpha
|
- | Series opacity (0-100%) |
gradient |
- | "color1-color2:angle" |
gradients |
- | Per-series gradients (semicolon-separated) |
secondaryAxis/secondary
|
- | Comma-separated 1-based series indices for secondary axis |
title.font/titlefont
|
- | Title typeface (font name) |
title.size/titlesize
|
- | Title font size (pt) |
title.color/titlecolor
|
- | Title font color (hex) |
title.bold/titlebold
|
- | Title bold (true/false) |
title.glow/titleglow
|
- | Title glow: "COLOR-RADIUS-OPACITY" or "none"
|
title.shadow/titleshadow
|
- | Title shadow: "COLOR-BLUR-ANGLE-DIST-OPACITY" or "none"
|
legendfont/legend.font
|
- | Legend font: "size:color:fontname" e.g. "9:8B949E:Helvetica Neue"
|
axisfont/axis.font
|
- | Axis label font: "size:color:fontname" e.g. "10:58626E:Arial"
|
series.shadow/seriesshadow
|
- | Series shadow: "COLOR-BLUR-ANGLE-DIST-OPACITY" or "none"
|
series.outline/seriesoutline
|
- | Series outline: "COLOR-WIDTH" e.g. "FFFFFF-0.5" or "none"
|
gapwidth/gap
|
- | Bar gap width (0-500) |
overlap |
- | Bar overlap (-100 to 100) |
view3d/camera/perspective
|
- | 3D rotation: "rotX,rotY,perspective" e.g. "15,20,30"
|
areafill/area.fill
|
- | Area gradient fill: "C1-C2[:angle]"
|
radarstyle |
- | Radar subtype (radar): standard/line, marker, filled/fill
|
autotitledeleted |
- | Suppress the auto-generated "Chart Title" placeholder (true/false) |
axisposition/axispos
|
- | Axis tick-label position / cross-between shortcut (e.g. top) |
bubbleScale |
- | Bubble chart scale (% of default, bubble only) |
catAxisVisible/cataxis.visible
|
- | Show/hide category axis (true/false) |
valaxisvisible/valaxis.visible
|
- | Show/hide value axis (true/false) |
chartborder/chartarea.border
|
- | Chart-area outer border line: color:width:dash or none
|
plotborder/plotarea.border
|
- | Plot-area border line: color, color:width, color:width:dash, or none
|
combotypes/combo.types
|
- | Rebuild as combo with per-series types, comma-separated one per series (e.g. "column,column,line") |
crossBetween |
- | Category axis cross-between: between / midCat
|
crosses |
- | Where value axis crosses category axis: autoZero (default), max, min
|
crossesAt |
- | Value-axis crosses-at numeric value |
dispBlanksAs |
- | How empty cells render: gap, zero, span
|
firstSliceAngle/sliceangle
|
- | Pie/doughnut first slice angle (degrees) |
gapdepth |
- | Depth gap between series in 3D bar/line/area charts (percent) |
holeSize |
- | Doughnut hole size (10-90 percent) |
leaderlines/showleaderlines
|
- | Show/hide leader lines connecting labels to slices (pie/doughnut) |
plotvisonly/plotvisibleonly
|
- | Skip plotting hidden worksheet rows/columns (true/false) |
shownegbubbles |
- | Render negative-valued bubbles (bubble only) |
sizerepresents |
- | How bubble size maps: area (default), width/w (bubble only) |
title.overlay/titleoverlay
|
- | Title overlays the plot area instead of reserving space above (true/false) |
trendline |
- | Trendline per series: type[:order] or type:forward:backward (linear, exp, log, poly, power, movingAvg); none clears |
valaxisline/valaxis.line
|
- | Value-axis line: color:width:dash
|
varyColors |
- | Vary colors by data point (true/false; single-series charts) |
referenceLine/refLine
|
- | Reference line: value or "value:color:width:dash"
|
colorRule/conditionalColor
|
- | Conditional coloring rule |
smooth |
- | Smooth line curves (line/scatter) |
showMarker/showMarkers
|
- | Toggle markers on line charts |
dropLines |
- | Show vertical drop lines (line charts) |
hiLowLines |
- | Show high-low lines (line/stock) |
upDownBars |
- | Show gain/loss bars (line/stock) |
serLines/seriesLines
|
- | Show series connector lines |
dataTable |
- | Show data table below chart |
roundedCorners |
- | Rounded corners on chart area |
preset/theme
|
- | Chart style preset |
plotArea.x/y/w/h |
- | Manual layout of plot area (0-1) |
title.x/y/w/h |
- | Manual layout of chart title (0-1) |
legend.x/y/w/h |
- | Manual layout of legend (0-1) |
legend.overlay |
- | Legend overlays chart area |
dataLabel{N}.text |
- | Custom text for data label N |
dataLabel{N}.x/y/w/h |
- | Manual layout of data label N |
dataLabels.separator |
- | Label separator |
dataLabels.numFmt |
- | Label number format |
series{N}.name |
- | Update series name |
series{N}.values |
- | Update series values |
axisLine/axis.line
|
- | Value axis line: "color:width:dash"
|
catAxisLine |
- | Category axis line: "color:width:dash"
|
axisVisible/axis.visible
|
- | Hide/show axes |
majorTickMark/majorTick
|
- | Major tick style |
minorTickMark/minorTick
|
- | Minor tick style |
tickLabelPos |
- | Tick label position |
axisOrientation/axisReverse
|
- | Reverse axis direction |
logBase/logScale
|
- | Logarithmic scale base |
dispUnits/displayUnits
|
- | Display units |
point{N}.color |
- | Individual data point color |
invertIfNeg |
- | Invert bars for negative values |
explosion/explode
|
- | Pie slice explosion |
errBars/errorBars
|
- | Error bars |
x, y, width, height
|
- | Chart position and size (EMU or units) |
Extended chart types (cx:chart — histogram, funnel, treemap, sunburst, boxWhisker):
Full Set vocabulary supported via the same command. Includes title/axis text styling, gridline color, binCount/binSize/intervalClosed (histogram), parentLabelLayout (treemap), quartileMethod (boxWhisker), and all regular-chart parity knobs.
officecli set report.docx /chart[1] --prop title="Updated Title" --prop legend=bottom
# Format chart title
officecli set report.docx /body/chart[1] --prop title.font=Arial --prop title.size=16 --prop title.bold=true
# Add legend font
officecli set report.docx /chart[1] --prop legendfont="9:8B949E:Helvetica Neue"
# Bar gap and overlap
officecli set report.docx /chart[1] --prop gapwidth=150 --prop overlap=20
# 3D perspective
officecli set report.docx /chart[1] --prop view3d="15,20,30"
# Series outline
officecli set report.docx /chart[1] --prop series.outline="FFFFFF-0.5"Based on OfficeCLI v1.0.64