Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

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

AltStyle によって変換されたページ (->オリジナル) /