-
Notifications
You must be signed in to change notification settings - Fork 528
ppt chart add
zmworm edited this page Jun 8, 2026
·
54 revisions
Add charts to a slide with data, series, and styling.
Path: /slide[N] (parent)
| Property | Default | Description |
|---|---|---|
chartType |
column |
Chart type (see types below) |
anchor |
- | Shorthand x,y,w,h (e.g. anchor=2cm,4cm,20cm,12cm) — equivalent to setting x/y/width/height individually. Available on Add and Set. |
title |
- | Chart title |
data |
- | Inline data (Series1:1,2,3;Series2:4,5,6) |
series1, series2, ... |
- | Named series (Name:val1,val2,val3) |
categories |
- | Comma-separated category labels |
colors |
auto | Comma-separated hex colors |
comboSplit |
- | Bar series count for combo charts |
x, y
|
defaults | Position (EMU or units) |
width, height
|
defaults | Size (EMU or units) |
name |
auto | Chart name |
legend |
- |
true/false, top, bottom, left, right, none
|
dataLabels |
- | Show data labels |
axisTitle |
- | Value axis title |
catTitle |
- | Category axis title |
axisMin, axisMax
|
- | Axis scale limits |
majorUnit |
- | Axis major unit |
minorUnit |
- | Axis minor unit |
axisNumFmt |
- | Axis number format |
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
|
smooth |
false |
Smooth line curves (line/scatter only) |
showMarker/showMarkers
|
- | Toggle markers on line charts |
dropLines |
false |
Show vertical drop lines from data points to X axis (line charts) |
hiLowLines |
false |
Show high-low lines (line/stock) |
upDownBars |
false |
Show gain/loss bars between first and last series (line/stock) |
dataTable |
false |
Show data table below chart |
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]"
|
| Base Type | Variants |
|---|---|
column |
columnStacked, columnPercentStacked, column3d
|
bar |
barStacked, barPercentStacked, bar3d
|
line |
lineStacked, linePercentStacked, line3d
|
pie |
pie3d |
doughnut |
|
area |
areaStacked, areaPercentStacked, area3d
|
scatter |
|
bubble |
|
radar |
spider |
stock |
ohlc |
combo |
Mixed chart types via comboSplit
|
waterfall |
wf |
funnel |
|
treemap |
|
sunburst |
|
histogram |
|
boxWhisker |
|
pieOfPie |
Pie chart with a secondary pie for tail values |
barOfPie |
Pie chart with a secondary stacked bar for tail values |
# Bar chart with two series officecli add slides.pptx /slide[1] --type chart --prop chartType=bar --prop title="Revenue by Quarter" --prop categories="Q1,Q2,Q3,Q4" --prop series1="2024:100,200,150,300" --prop series2="2023:80,180,140,250" --prop x=2cm --prop y=4cm --prop width=20cm --prop height=12cm # Pie chart officecli add slides.pptx /slide[2] --type chart --prop chartType=pie --prop title="Market Share" --prop categories="Product A,Product B,Product C" --prop data="Share:40,35,25" --prop colors=4472C4,ED7D31,A5A5A5 # Line chart with axis titles officecli add slides.pptx /slide[1] --type chart --prop chartType=line --prop title="Trend" --prop categories="Jan,Feb,Mar,Apr" --prop series1="Sales:10,20,15,30" --prop axisTitle="USD" --prop catTitle="Month" --prop legend=bottom # Radar chart officecli add slides.pptx /slide[1] --type chart --prop chartType=radar --prop title="Skills" --prop categories="Code,Design,PM" --prop data="Team:8,6,7" # Bubble chart officecli add slides.pptx /slide[1] --type chart --prop chartType=bubble --prop title="Market" --prop categories="10,20,30" --prop series1="Products:100,200,150" # Stock chart (OHLC) officecli add slides.pptx /slide[1] --type chart --prop chartType=stock --prop categories="Mon,Tue,Wed" --prop series1="Open:100,102,101" --prop series2="High:105,108,106" --prop series3="Low:98,100,99" --prop series4="Close:103,101,104"
Per-series add and remove on /slide[N]/chart[M]/series[K]:
# Append a new series (clones last c:ser structure; theme palette color auto-assigned) officecli add deck.pptx /slide[1]/chart[1] --type series --prop name="2026" --prop data="100,200,150,300" # Remove a series (survivors renumbered) officecli remove deck.pptx /slide[1]/chart[1]/series[2]
Chart paths support animation Add/Set/Query/Remove:
officecli add deck.pptx /slide[1]/chart[1]/animation --type animation --prop effect=fade --prop chartBuild=byCategory officecli query deck.pptx /slide[1]/chart[1]/animation
chartBuild accepts asOneObject, bySeries, byCategory, bySeriesInCategory, byCategoryInSeries for per-series/category build effects.
Per-attribute axisLine and gridline setters on chart-axis paths:
officecli set deck.pptx /slide[1]/chart[1]/categoryAxis --prop axisLine.color=4472C4 --prop axisLine.width=1pt officecli set deck.pptx /slide[1]/chart[1]/valueAxis --prop gridline.color=DDDDDD --prop gridline.dash=dash
Line charts also emit dropLines/hiLowLines/upDownBars on Get so dump → batch round-trips them.
Based on OfficeCLI v1.0.97