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)

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
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

---

Based on OfficeCli v1.0.6