Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

excel chart funnel

zmworm edited this page Apr 13, 2026 · 16 revisions

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


Based on OfficeCLI v1.0.43

Clone this wiki locally

AltStyle によって変換されたページ (->オリジナル) /