A dedicated page for the stock (OHLC) chart type. Stock charts display financial data with high-low-close (HLC) or open-high-low-close (OHLC) candlestick visualization.

Path: /{SheetName}/chart[N]

See also: Chart - add, Chart - set.

Stock charts require series in a specific order:

# HLC (3 series)
officecli add data.xlsx /Sheet1 --type chart \
 --prop chartType=stock \
 --prop categories="Mon,Tue,Wed,Thu,Fri" \
 --prop series1="High:105,108,106,110,107" \
 --prop series2="Low:98,100,99,102,100" \
 --prop series3="Close:103,101,104,107,103"
# OHLC (4 series) — full candlestick
officecli add data.xlsx /Sheet1 --type chart \
 --prop chartType=stock \
 --prop categories="Mon,Tue,Wed,Thu,Fri" \
 --prop series1="Open:100,102,101,105,108" \
 --prop series2="High:105,108,106,110,112" \
 --prop series3="Low:98,100,99,102,105" \
 --prop series4="Close:103,101,104,107,110"

The stock chart renders as:

• High-low wicks: vertical lines from high to low at each category
• Open-close bars (4-series only): filled rectangles between open and close prices
• Up bars: white/green fill when close > open (bullish)
• Down bars: black/red fill when close < open (bearish)

Default colors: up = #FFFFFF (white), down = #000000 (black).

• Chart - Overview
• Chart add - Add a chart
• Line chart - Drop lines, high-low lines, up-down bars (shared elements)

Based on OfficeCLI v1.0.43