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

Combo Charts Showcase

This demo consists of three files that work together:

• charts-combo.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-combo.xlsx — The generated workbook with 5 sheets (1 default + 4 chart sheets, 16 charts total).
• charts-combo.md — This file. Maps each sheet to the features it demonstrates.

Regenerate

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

Chart Sheets

Sheet: 1-Combo Fundamentals

Four combo charts covering comboSplit, secondaryAxis, combotypes, and combined usage.

# Basic combo: 2 bar series + 1 line via comboSplit
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop series1="Revenue:120,145,160,180,195" \
  --prop series2="Expenses:90,100,110,115,125" \
  --prop series3="Margin %:25,31,31,36,36" \
  --prop comboSplit=2 --prop legend=bottom

# Combo with secondary Y-axis for line series
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop comboSplit=1 --prop secondaryAxis=2 \
  --prop catTitle=Year --prop axisTitle=Sales ($K)

# Per-series type control via combotypes
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop combotypes=column,column,line,area

# combotypes + secondaryAxis together
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop combotypes=column,column,line \
  --prop secondaryAxis=3

Features: combo, comboSplit, secondaryAxis, combotypes=column,column,line,area, catTitle, axisTitle

Sheet: 2-Combo Styling

Four styled combo charts with title fonts, gradients, data labels, and chart fills.

# Title, legend, axis font styling
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop title.font=Georgia --prop title.size=16 \
  --prop title.color=1F4E79 --prop title.bold=true \
  --prop legendfont=10:333333:Calibri --prop axisfont=9:666666

# Series shadow and gradients
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop 'gradients=1F4E79-5B9BD5:90;C55A11-F4B183:90' \
  --prop series.shadow=000000-4-315-2-30

# Data labels on combo series
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop dataLabels=true --prop labelPos=top \
  --prop labelFont=9:333333:true

# Chart area styling
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop plotFill=F0F4F8 --prop chartFill=FAFAFA \
  --prop roundedCorners=true

Features: title.font/size/color/bold, legendfont, axisfont, gradients, series.shadow, dataLabels, labelPos, labelFont, plotFill, chartFill, roundedCorners

Sheet: 3-Combo Advanced

Four advanced combo charts with reference lines, axis scaling, layout, and markers.

# Reference line and gridlines
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop referenceLine=110:Target:C00000 \
  --prop gridlines=D9D9D9:0.5

# Axis scaling and display units
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop axisMin=1000000 --prop axisMax=2000000 \
  --prop dispUnits=thousands

# Manual plot layout
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop plotLayout=0.1,0.15,0.85,0.75

# Multiple line series with markers
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop comboSplit=1 --prop secondaryAxis=2,3,4 \
  --prop markers=circle-6

Features: referenceLine, gridlines, axisMin/Max, dispUnits, plotLayout, markers, multiple secondary axis series

Sheet: 4-Combo Effects

Four effect-heavy combo charts with glow, borders, color rules, and complex multi-series.

# Title glow and shadow effects
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop title.glow=4472C4-6 \
  --prop title.shadow=000000-3-315-2-30

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

# Color rule (conditional bar coloring)
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop colorRule=80:C00000:70AD47

# 5-series dashboard with mixed combotypes
officecli add data.xlsx /Sheet --type chart \
  --prop chartType=combo \
  --prop combotypes=column,column,column,area,line \
  --prop secondaryAxis=5

Features: title.glow, title.shadow, chartArea.border, plotArea.border, colorRule, 5-series combotypes

Inspect the Generated File

officecli query charts-combo.xlsx chart
officecli get charts-combo.xlsx "/1-Combo Fundamentals/chart[1]"