excel chart

Excel: Chart

Embedded charts for data visualization.

Path: /{SheetName}/chart[N]

Operations

• get - Returned attributes and output format

• add - Add a chart (column, bar, line, pie, combo, etc.)

• set - Modify chart title, type, legend, and size

Chart types with dedicated pages

Charts fall into two families with substantially different vocabularies: regular cChart (column / bar / line / pie / area / scatter / bubble / radar / stock / combo / waterfall) and extended cx:chart (histogram / funnel / treemap / sunburst / boxWhisker). The shared vocabulary lives in add and set, but each type also has type-specific knobs that deserve their own page.

• column — gap width, overlap, bar shape, invert-if-negative, stacked/percent/3D variants
• bar — horizontal variant of column, same properties
• line — smooth curves, dash patterns, markers (10 shapes), drop lines, high-low lines, up-down bars, data tables, reference lines, log scale, reversed axis, dual axis, 3D variant
• pie — explosion, first slice angle, per-slice colors, percentage labels, 3D variant
• doughnut — ring chart with hole size, explosion, per-slice colors
• area — filled regions, stacked/percent/3D variants, gradient fill, transparency
• scatter — XY numeric axes, 5 scatter styles (marker, line, lineMarker, smooth, smoothMarker)
• bubble — bubble scale, size-represents (width/area), negative bubbles, XY + size data
• radar — polar grid, 3 radar styles (standard, filled, marker)
• stock — OHLC candlestick, high-low wicks, up/down bars, 3 or 4 series order
• combo — multi-type overlay (column + line), combo split, per-series type assignment, dual axis
• waterfall — bridge chart with increase/decrease/total colors, floating bar effect
• funnel — cx extended chart, progressive narrowing bars for pipeline/conversion stages
• treemap — cx extended chart, nested rectangles with proportional areas (parentLabelLayout)
• sunburst — cx extended chart, concentric ring segments for hierarchical data
• boxWhisker — cx extended chart, statistical box plot with quartiles, whiskers, outliers (quartileMethod)
• histogram — cx extended chart with binning (binCount / binSize / underflowBin / overflowBin / intervalClosed) plus the full cx styling vocabulary

get

officecli get data.xlsx /Sheet1/chart[1]
officecli get data.xlsx /Sheet1/chart[2]

remove

officecli remove data.xlsx /Sheet1/chart[1]

---

Based on OfficeCLI v1.0.64