excel chart funnel

Excel: Chart - funnel

A dedicated page for the funnel chart type. Funnel charts are part of Excel's cx:chart (extended chart, Office 2016+) family. They display values as progressively narrowing horizontal bars, ideal for pipeline stages, conversion funnels, and filtering processes.

Path: /{SheetName}/chart[N]

See also: Chart - add, Chart - set, histogram for the full cx styling vocabulary (shared across all cx types).

Data format

Single series with numeric values. Categories provide stage labels.

officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=funnel \
  --prop title="Sales Funnel" \
  --prop series1="Pipeline:1000,800,400,200,100" \
  --prop categories="Leads,Qualified,Proposal,Negotiation,Won"

Funnel-specific properties

Funnel has no unique properties beyond the shared cx vocabulary. All styling is done via the common cx knobs documented below.

Shared cx styling vocabulary

All cx:chart types (funnel, treemap, sunburst, boxWhisker, histogram) share these properties:

Title

Property	Default	Notes
title	—	Chart title; none/false to hide
title.color / titleColor	—	Hex color
title.size / titleSize	—	Font size (pt)
title.bold / titleBold	—	Bold
title.font / titleFont	—	Font family
title.shadow / titleShadow	—	"COLOR-BLUR-ANGLE-DIST-OPACITY" or "none"

Legend

Property	Default	Notes
legend	—	top, bottom, left, right, none
legend.overlay	false	Float on chart
legendFont / legend.font	—	"size:color:fontname"

Series colors

Property	Default	Notes
fill	theme	Single hex color for all bars
colors	theme	Comma-separated hex colors
series.shadow / seriesShadow	—	"COLOR-BLUR-ANGLE-DIST-OPACITY" or "none"

Data labels

Property	Default	Notes
dataLabels	false	Show value labels
dataLabels.numFmt	—	Number format code

Plot and chart area

Property	Default	Notes
plotAreaFill / plotFill	—	Hex color or "none"
plotArea.border / plotBorder	—	"color:width:dash" or "none"
chartAreaFill / chartFill	—	Hex color or "none"
chartArea.border / chartBorder	—	"color:width:dash" or "none"

Axis labels

Property	Default	Notes
axisFont / axis.font	—	"size:color:fontname" for tick labels

Example

officecli add data.xlsx /Sheet1 --type chart \
  --prop chartType=funnel \
  --prop title="Conversion Funnel" \
  --prop title.size=16 --prop title.bold=true \
  --prop series1="Users:10000,6000,3000,1500,500" \
  --prop categories="Visit,Signup,Activate,Subscribe,Renew" \
  --prop fill=5B9BD5 \
  --prop "series.shadow=000000-6-45-3-35" \
  --prop plotFill=F8F9FA \
  --prop dataLabels=true

HTML preview support

Feature	Preview	Notes
Centered horizontal bars	Yes	Width proportional to value
Category + value labels	Yes
Series colors	Yes
Plot/chart area fills	Yes

See Also

• Chart - Overview
• histogram - Full cx styling reference
• treemap - Hierarchical area
• sunburst - Hierarchical rings
• boxWhisker - Statistical distribution

---

Based on OfficeCLI v1.0.43