iofficeai--officecli/examples/ppt/charts/charts-3d.md

3D Charts Showcase

This demo consists of three files that work together:

• charts-3d.py — Python script that calls officecli commands to generate the deck.
• charts-3d.pptx — The generated 8-slide deck (4 charts per slide, 32 charts total).
• charts-3d.md — This file. Maps each slide to the 3D chart features it demonstrates.

Regenerate

cd examples/ppt/charts
python3 charts-3d.py
# → charts-3d.pptx

Chart Slides

Slide 1 — 3D Families

CATS="Q1,Q2,Q3,Q4"
D2="East:120,135,148,162;West:95,108,115,128"

officecli add charts-3d.pptx /slide[1] --type chart \
  --prop chartType=column3d --prop title="column3d" --prop legend=bottom \
  --prop categories="$CATS" --prop data="$D2" \
  --prop x=0.3in --prop y=1.05in --prop width=6.1in --prop height=3in

officecli add charts-3d.pptx /slide[1] --type chart \
  --prop chartType=bar3d --prop title="bar3d" --prop legend=bottom \
  --prop categories="$CATS" --prop data="$D2" \
  --prop x=6.95in --prop y=1.05in --prop width=6.1in --prop height=3in

officecli add charts-3d.pptx /slide[1] --type chart \
  --prop chartType=pie3d --prop title="pie3d" --prop legend=right \
  --prop categories="North,South,East,West" --prop data="Share:30,25,28,17" \
  --prop x=0.3in --prop y=4.25in --prop width=6.1in --prop height=3in

officecli add charts-3d.pptx /slide[1] --type chart \
  --prop chartType=line3d --prop title="line3d" --prop legend=bottom \
  --prop categories="$CATS" --prop data="$D2" \
  --prop x=6.95in --prop y=4.25in --prop width=6.1in --prop height=3in

Features: chartType (column3d/bar3d/pie3d/line3d)

Slide 2 — area3d and Stacked 3D

D3="East:120,135,148,162;South:95,108,115,128;West:80,90,98,110"

officecli add charts-3d.pptx /slide[2] --type chart \
  --prop chartType=area3d --prop title="area3d" --prop legend=bottom \
  --prop categories="$CATS" --prop data="$D2"

officecli add charts-3d.pptx /slide[2] --type chart \
  --prop chartType=stackedColumn3d --prop title="stackedColumn3d" --prop legend=bottom \
  --prop categories="$CATS" --prop data="$D3"

officecli add charts-3d.pptx /slide[2] --type chart \
  --prop chartType=percentStackedColumn3d --prop title="percentStackedColumn3d" \
  --prop legend=bottom --prop categories="$CATS" --prop data="$D3"

officecli add charts-3d.pptx /slide[2] --type chart \
  --prop chartType=stackedBar3d --prop title="stackedBar3d" --prop legend=bottom \
  --prop categories="$CATS" --prop data="$D3"

Features: chartType (area3d/stackedColumn3d/percentStackedColumn3d/stackedBar3d)

Slide 3 — view3d Angles

view3d accepts up to three comma-separated values: rotX,rotY,perspective.

# Low elevation, slight rotation
officecli add charts-3d.pptx /slide[3] --type chart \
  --prop chartType=column3d --prop title="view3d=15,20,30" \
  --prop view3d="15,20,30" --prop legend=none \
  --prop categories="$CATS" --prop data="$D2"

# Higher elevation + wider rotation
officecli add charts-3d.pptx /slide[3] --type chart \
  --prop chartType=column3d --prop title="view3d=30,40,15" \
  --prop view3d="30,40,15" --prop legend=none \
  --prop categories="$CATS" --prop data="$D2"

# Single value: sets rotX only
officecli add charts-3d.pptx /slide[3] --type chart \
  --prop chartType=column3d --prop title="view3d=20 (rotX only)" \
  --prop view3d="20" --prop legend=none \
  --prop categories="$CATS" --prop data="$D2"

# Pie 3D with all three parameters
officecli add charts-3d.pptx /slide[3] --type chart \
  --prop chartType=pie3d --prop title="pie3d view3d=40,30,30" \
  --prop view3d="40,30,30" --prop legend=right \
  --prop categories="North,South,East,West" --prop data="Share:30,25,28,17"

Features: view3d (rotX,rotY,perspective — one, two, or three values)

Slide 4 — gapdepth

Controls the depth spacing between bars/columns in the Z direction (0–500).

for g in 0 50 150 300; do
  officecli add charts-3d.pptx /slide[4] --type chart \
    --prop chartType=column3d --prop title="gapdepth=$g" \
    --prop gapdepth=$g --prop legend=none \
    --prop categories="$CATS" --prop data="$D2"
done

Features: gapdepth (0–500, 3D depth spacing between series groups)

Slide 5 — 3D Bar Shapes

for s in box cylinder cone pyramid; do
  officecli add charts-3d.pptx /slide[5] --type chart \
    --prop chartType=bar3d --prop shape=$s --prop title="shape=$s" \
    --prop legend=none --prop categories="$CATS" --prop data="$D2"
done

Features: shape (box/cylinder/cone/pyramid) for bar3d and column3d

Slide 6 — Title and Legend

officecli add charts-3d.pptx /slide[6] --type chart \
  --prop chartType=column3d --prop title="Styled title" \
  --prop title.font=Georgia --prop title.size=20 \
  --prop title.color=4472C4 --prop title.bold=true \
  --prop legend=bottom --prop categories="$CATS" --prop data="$D2"

officecli add charts-3d.pptx /slide[6] --type chart \
  --prop chartType=column3d --prop title="legend=top + legendFont" \
  --prop legend=top --prop legendFont="10:333333:Calibri" \
  --prop categories="$CATS" --prop data="$D2"

officecli add charts-3d.pptx /slide[6] --type chart \
  --prop chartType=column3d --prop title="legend.overlay=true" \
  --prop legend=topRight --prop legend.overlay=true \
  --prop categories="$CATS" --prop data="$D2"

officecli add charts-3d.pptx /slide[6] --type chart \
  --prop chartType=column3d --prop autotitledeleted=true --prop legend=none \
  --prop categories="$CATS" --prop data="$D2"

Features: title.font/size/color/bold, legend positions, legendFont, legend.overlay, autotitledeleted

Slide 7 — Series Styling

officecli add charts-3d.pptx /slide[7] --type chart \
  --prop chartType=column3d --prop title="colors + seriesoutline" \
  --prop colors="4472C4,ED7D31" --prop seriesoutline="000000:0.5" \
  --prop legend=bottom --prop categories="$CATS" --prop data="$D2"

officecli add charts-3d.pptx /slide[7] --type chart \
  --prop chartType=column3d --prop title="gradient + seriesshadow" \
  --prop gradient="FF6600-FFCC00" --prop seriesshadow="000000-5-45-3-50" \
  --prop legend=none --prop categories="$CATS" --prop data="$D2"

officecli add charts-3d.pptx /slide[7] --type chart \
  --prop chartType=column3d --prop title="transparency=30" \
  --prop transparency=30 --prop legend=bottom \
  --prop categories="$CATS" --prop data="$D2"

officecli add charts-3d.pptx /slide[7] --type chart \
  --prop chartType=column3d --prop title="per-series gradients" \
  --prop gradients="FF0000-0000FF;00FF00-FFFF00" --prop legend=bottom \
  --prop categories="$CATS" --prop data="$D2"

Features: colors, seriesoutline, gradient, seriesshadow, transparency, gradients

Slide 8 — Presets

for p in minimal dark corporate colorful; do
  officecli add charts-3d.pptx /slide[8] --type chart \
    --prop chartType=column3d --prop preset=$p --prop title="preset=$p" \
    --prop view3d="15,20,30" --prop legend=bottom \
    --prop categories="$CATS" --prop data="$D2"
done

Features: preset (minimal/dark/corporate/colorful) applied to 3D chart type

Complete Feature Coverage

Feature	Slide
3D chart types: column3d, bar3d, pie3d, line3d	1
3D chart types: area3d, stackedColumn3d, percentStackedColumn3d, stackedBar3d	2
view3d (rotX,rotY,perspective)	1, 3
gapdepth (0–500)	4
shape (box/cylinder/cone/pyramid) — bar3d/column3d	5
title.font/size/color/bold	6
legend positions, legendFont, legend.overlay	6
autotitledeleted	6
colors, seriesoutline, gradient, seriesshadow	7
transparency, gradients	7
preset (minimal/dark/corporate/colorful)	8

Inspect the Generated File

officecli query charts-3d.pptx chart
officecli get charts-3d.pptx "/slide[1]/chart[1]"
officecli get charts-3d.pptx "/slide[3]/chart[1]"
officecli get charts-3d.pptx "/slide[4]/chart[2]"