-
Notifications
You must be signed in to change notification settings - Fork 1.1k
ppt chart set
goworm edited this page Jun 26, 2026
·
53 revisions
Modify chart properties including title, legend, data labels, and position.
Path: /slide[N]/chart[M]
| Property | Accepted Values | Description |
|---|---|---|
title |
text | Chart title |
legend |
top, bottom, left, right, none
|
Legend position |
dataLabels |
comma-separated: value, category, series, percent, all, none, true
|
Show data labels |
colors |
comma-separated hex | Series colors |
axisTitle / vTitle
|
text | Value axis title |
catTitle / hTitle
|
text | Category axis title |
axisMin / min
|
number | Value axis minimum |
axisMax / max
|
number | Value axis maximum |
majorUnit |
number | Major axis unit interval |
minorUnit |
number | Minor axis unit interval |
axisNumFmt / axisNumberFormat
|
format code | Value axis number format |
categories |
comma-separated | Category labels |
data |
Series1:1,2,3;Series2:4,5,6 |
Chart data (all series) |
series1..seriesN
|
Name:val1,val2 |
Individual series data |
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 |
referenceLine/refLine
|
value or "value:color:width:dash"
|
Reference/target line |
colorRule/conditionalColor
|
rule expression | Conditional coloring |
smooth |
bool | Smooth line curves (line/scatter) |
showMarker/showMarkers
|
bool | Toggle markers |
dropLines |
bool | Show vertical drop lines (line charts) |
hiLowLines |
bool | Show high-low lines (line/stock) |
upDownBars |
bool | Show gain/loss bars (line/stock) |
dataTable |
bool | Show data table below chart |
roundedCorners |
bool | Rounded corners |
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 title |
legend.x/y/w/h |
decimal (0-1) | Manual layout of legend |
legend.overlay |
bool | Legend overlays chart |
dataLabel{N}.text |
string | Custom data label text |
dataLabel{N}.x/y/w/h |
decimal (0-1) | Manual data label layout |
dataLabels.separator |
string | Label separator |
dataLabels.numFmt |
format code | Label number format |
series{N}.name |
string | Update series name |
series{N}.values |
comma-separated | Update series values |
axisLine/axis.line
|
"color:width:dash" |
Value axis line |
catAxisLine |
"color:width:dash" |
Category axis line |
axisVisible/axis.visible
|
bool | Hide/show axes |
majorTickMark |
tick style | Major tick marks |
minorTickMark |
tick style | Minor tick marks |
tickLabelPos |
position | Tick label position |
axisOrientation/axisReverse
|
bool | Reverse axis |
logBase/logScale
|
number | Log scale base |
dispUnits/displayUnits
|
unit keyword | Display units |
point{N}.color |
hex color | Data point color |
invertIfNeg |
bool | Invert negative bars |
explosion/explode
|
0-400 | Pie explosion |
errBars/errorBars
|
type | Error bars |
name |
text | Chart element name |
x, y
|
EMU or units | Position |
width, height
|
EMU or units | Size |
autotitledeleted |
bool | Suppress the auto-generated 'Chart Title' placeholder |
axisposition/axispos
|
position | Convenience shortcut for axis tick label position / cross-between |
bubbleScale/bubblescale
|
number | Bubble chart scale (% of default). Bubble charts only |
catAxisVisible/cataxis.visible
|
bool | Hide/show the category axis |
valaxisvisible/valaxis.visible
|
bool | Hide/show the value axis |
chartborder/chartarea.border
|
"color:width:dash" or "none"
|
Chart-area outer border line |
plotborder/plotarea.border
|
"color[:width[:dash]]" or "none"
|
Plot-area border line |
combotypes/combo.types
|
comma-separated types | Rebuild as combo chart with per-series chart types (e.g. "column,column,line") |
crossBetween/crossbetween
|
between, midCat
|
Category axis cross-between behavior |
crosses |
autoZero, max, min
|
Where the value axis crosses the category axis |
crossesAt/crossesat
|
number | Value-axis crossesAt value |
firstSliceAngle/firstsliceangle/sliceangle
|
number (degrees) | Pie/doughnut first slice angle |
gapdepth |
number (percent) | Depth gap between series in 3D bar/line/area charts |
holeSize/holesize
|
number (10..90) | Doughnut hole size (percent). Doughnut charts only |
labeloffset |
number (0..1000) | Category-axis label offset (percent of font height) |
labelrotation |
number (-90..90) | Tick-label rotation in degrees; xaxis.* targets category, yaxis.*/valaxis.* targets value |
leaderlines/showleaderlines
|
bool | Show/hide leader lines connecting data labels to slices (pie/doughnut) |
markercolor/marker.color
|
hex color | Marker fill color (line/scatter/radar series); fans out to every applicable series |
plotvisonly/plotvisibleonly
|
bool | If true, skip plotting hidden worksheet rows/columns |
radarstyle |
standard/line, marker, filled/fill
|
Radar chart subtype. Radar charts only |
scatterstyle |
line, lineMarker, marker, smooth, smoothMarker
|
Scatter chart subtype. Scatter charts only |
serlines/serieslines
|
bool | Series lines on stacked bar charts |
shownegbubbles |
bool | Render negative-valued bubbles. Bubble charts only |
sizerepresents |
area, width/w
|
How bubble size value is mapped. Bubble charts only |
ticklabelskip/tickskip
|
number | Draw tick labels every Nth category (category axis) |
title.overlay/titleoverlay
|
bool | Title overlays the plot area instead of reserving space above |
trendline |
type[:order] or type:forward:backward
|
Add trendline to every series. Types: linear, exp, log, poly, power, movingAvg; none clears |
varyColors |
bool | Vary colors by data point (single-series charts) |
# Update title and legend
officecli set slides.pptx /slide[1]/chart[1] --prop title="Updated" --prop legend=bottom --prop x=1cm --prop width=22cm
# Show data labels
officecli set slides.pptx /slide[1]/chart[1] --prop dataLabels=true
# Reposition chart
officecli set slides.pptx /slide[1]/chart[1] --prop x=2cm --prop y=3cm --prop width=20cm --prop height=12cm
# Format chart title
officecli set slides.pptx /slide[1]/chart[1] --prop title.font=Arial --prop title.size=16 --prop title.bold=true
# Bar gap and overlap
officecli set slides.pptx /slide[1]/chart[1] --prop gapwidth=150 --prop overlap=20
# Series outline
officecli set slides.pptx /slide[1]/chart[1] --prop series.outline="FFFFFF-0.5"Based on OfficeCLI v1.0.64