excel chart stock

Excel: Chart - stock

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.

Chart type variants

Type string	Aliases
stock	ohlc

Series order requirement

Stock charts require series in a specific order:

Series count	Order	Display
3 series	High, Low, Close	High-low lines with close markers
4 series	Open, High, Low, Close	Full candlestick chart

# 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"

Stock-specific rendering

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

HTML preview support

Feature	Preview	Notes
Candlestick bars	Yes	Open-close rectangles
High-low wicks	Yes	Vertical lines
Up/down coloring	Yes	From OOXML or defaults

See Also

• 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