excel chart add

Excel: Chart - add

Add an embedded chart for data visualization.

Path: /{SheetName}

Properties

Property	Default	Description
chartType	(required)	Chart type (see types below)
title		Chart title
data		Inline data: Series1:1,2,3;Series2:4,5,6
series1, series2, ...		Named series: Name:val1,val2,val3
categories		Category labels (comma-separated, e.g., Q1,Q2,Q3,Q4)
colors		Color palette (comma-separated hex RGB)
x	0	Horizontal position
y	0	Vertical position
width	8	Chart width (column units)
height	15	Chart height (row units)
legend	true	Show legend (true/false; position defaults to bottom). Use none to hide
catTitle / htitle		Category (X) axis title
axisTitle / vtitle		Value (Y) axis title
comboSplit		Number of bar series in combo chart (integer)
dataLabels	false	Show data labels (bool)
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]"

Chart types

Type	Variants
column	column, columnStacked, columnPercentStacked, column3d
bar	bar, barStacked, barPercentStacked, bar3d
line	line, lineStacked, linePercentStacked, line3d
pie	pie, pie3d
doughnut	doughnut
area	area, areaStacked, areaPercentStacked, area3d
scatter	scatter
bubble	bubble
radar	radar, spider
stock	stock, ohlc
combo	combo

Examples

officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=column \
  --prop title="Monthly Sales" \
  --prop data="Sales:10,20,30,40;Costs:5,10,15,20" \
  --prop categories="Q1,Q2,Q3,Q4" \
  --prop x=5 --prop y=1

officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=pie \
  --prop title="Market Share" \
  --prop series1="Share:40,30,20,10" \
  --prop categories="A,B,C,D"

officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=lineStacked \
  --prop title="Trends" \
  --prop series1="Revenue:100,200,300" \
  --prop series2="Profit:50,80,120" \
  --prop categories="Jan,Feb,Mar" \
  --prop colors="FF0000,00FF00" \
  --prop catTitle="Month" \
  --prop axisTitle="Revenue"

officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=combo \
  --prop title="Revenue vs Growth" \
  --prop series1="Revenue:100,200,300" \
  --prop series2="Growth:5,8,12" \
  --prop categories="Q1,Q2,Q3" \
  --prop comboSplit=1 \
  --prop dataLabels=true

# Bubble chart
officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=bubble \
  --prop title="Market" \
  --prop categories="10,20,30" \
  --prop series1="Products:100,200,150"

# Radar chart
officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=radar \
  --prop title="Skills" \
  --prop categories="Code,Design,PM" \
  --prop data="Team:8,6,7"

# Stock chart (OHLC)
officecli add data.xlsx /Sheet1 --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"

---

Based on OfficeCLI v1.0.18