iofficeai--officecli/examples/excel/charts/charts-stock.md

Stock Charts Showcase

This demo consists of three files that work together:

• charts-stock.py — Python script that calls officecli commands to generate the workbook. Each chart command is shown as a copyable shell command in the comments.
• charts-stock.xlsx — The generated workbook with 4 sheets (1 default + 3 chart sheets, 12 charts total).
• charts-stock.md — This file. Maps each sheet to the features it demonstrates.

Regenerate

cd examples/excel
python3 charts-stock.py
# -> charts-stock.xlsx

Chart Sheets

Sheet: 1-Stock Fundamentals

Four OHLC stock charts covering basic rendering, gridlines, hi-low lines, and up-down bars.

# Basic OHLC stock chart with axis titles
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=stock \
  --prop series1="Open:142,145,148,150,147,152" \
  --prop series2="High:148,151,155,156,153,158" \
  --prop series3="Low:139,142,145,147,144,149" \
  --prop series4="Close:145,148,150,147,152,155" \
  --prop catTitle=Week --prop axisTitle=Price ($)

# Stock with gridlines and axis font
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=stock \
  --prop gridlines=D9D9D9:0.5 --prop axisfont=9:666666

# Hi-low lines connecting high to low per category
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=stock \
  --prop hiLowLines=true

# Up-down bars showing open-to-close direction
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=stock \
  --prop updownbars=100:70AD47:C00000

Features: stock, 4-series OHLC, catTitle, axisTitle, gridlines, axisfont, hiLowLines, updownbars=gapWidth:upColor:downColor

Sheet: 2-Stock Styling

Four styled stock charts with title fonts, axis lines, custom ranges, and chart fills.

# Title and legend styling
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=stock \
  --prop title.font=Georgia --prop title.size=16 \
  --prop title.color=1F4E79 --prop title.bold=true \
  --prop legend=right --prop legendfont=10:333333:Calibri

# Axis line styling
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=stock \
  --prop axisLine=333333-1.5 --prop catAxisLine=333333-1.5

# Custom axis range with major unit
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=stock \
  --prop axisMin=110 --prop axisMax=150 --prop majorUnit=10

# Chart area fills and rounded corners
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=stock \
  --prop plotFill=F0F4F8 --prop chartFill=FAFAFA \
  --prop roundedCorners=true

Features: title.font/size/color/bold, legend=right, legendfont, axisLine, catAxisLine, axisMin/Max, majorUnit, plotFill, chartFill, roundedCorners

Sheet: 3-Stock Advanced

Four advanced stock charts with data labels, reference lines, borders, and number formatting.

# Data labels on stock chart
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=stock \
  --prop dataLabels=true --prop labelPos=top \
  --prop labelFont=8:666666:false

# Reference line as support/resistance level
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=stock \
  --prop referenceLine=115:Resistance:C00000

# Chart and plot area borders
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=stock \
  --prop chartArea.border=333333-1.5 \
  --prop plotArea.border=999999-0.75

# Axis number format (dollar)
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=stock \
  --prop axisNumFmt=$#,##0

Features: dataLabels, labelPos, labelFont, referenceLine, chartArea.border, plotArea.border, axisNumFmt

Inspect the Generated File

officecli query charts-stock.xlsx chart
officecli get charts-stock.xlsx "/1-Stock Fundamentals/chart[1]"