Skip to content

excel chart

zmworm edited this page Apr 11, 2026 · 55 revisions

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.

  • histogram — cx extended chart with binning (binCount / binSize / underflowBin / overflowBin / intervalClosed) plus the full cx styling vocabulary (plot / chart area fills and borders, axis scaling, gridline / axis line colors, data labels, axis-title typography, shadows, legend font).

More type-specific pages coming; until then use the generic add and set pages plus the examples/excel/ runnable demos.

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

Clone this wiki locally