excel chart set

Excel: Chart - set

Modify an existing chart's properties.

Path: /{SheetName}/chart[N]

Properties

Property	Accepted Values	Description
title	string	Update chart title
legend	position keyword	Update legend position
catTitle / hTitle	string	Update category axis title
axisTitle / vTitle	string	Update value axis title
dataLabels / labels	comma-separated: value,category,series,percent,all,none,true	Configure data labels
colors	comma-separated hex RGB	Update color palette
axisMin / min	number	Minimum value for value axis
axisMax / max	number	Maximum value for value axis
majorUnit	number	Major unit interval for value axis
minorUnit	number	Minor unit interval for value axis
axisNumFmt / axisNumberFormat	format code	Number format for value axis
categories	comma-separated	Update category labels
data	Series1:1,2,3;Series2:4,5,6	Update all series data
series1..seriesN	Name:val1,val2	Update individual series

Examples

officecli set data.xlsx /Sheet1/chart[1] --prop title="Updated Sales Chart"
officecli set data.xlsx /Sheet1/chart[1] --prop legend=bottom
officecli set data.xlsx /Sheet1/chart[1] --prop catTitle="Month" --prop axisTitle="Revenue"

---

Based on OfficeCli v1.0.6