-
Notifications
You must be signed in to change notification settings - Fork 541
excel chart funnel
zmworm edited this page Apr 13, 2026
·
16 revisions
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).
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 has no unique properties beyond the shared cx vocabulary. All styling is done via the common cx knobs documented below.
All cx:chart types (funnel, treemap, sunburst, boxWhisker, histogram) share these properties:
| 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"
|
| Property | Default | Notes |
|---|---|---|
legend |
— |
top, bottom, left, right, none
|
legend.overlay |
false |
Float on chart |
legendFont / legend.font
|
— | "size:color:fontname" |
| 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"
|
| Property | Default | Notes |
|---|---|---|
dataLabels |
false |
Show value labels |
dataLabels.numFmt |
— | Number format code |
| 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"
|
| Property | Default | Notes |
|---|---|---|
axisFont / axis.font
|
— |
"size:color:fontname" for tick labels |
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
| Feature | Preview | Notes |
|---|---|---|
| Centered horizontal bars | Yes | Width proportional to value |
| Category + value labels | Yes | |
| Series colors | Yes | |
| Plot/chart area fills | Yes |
- Chart - Overview
- histogram - Full cx styling reference
- treemap - Hierarchical area
- sunburst - Hierarchical rings
- boxWhisker - Statistical distribution
Based on OfficeCLI v1.0.43